Question: Consider the data below, which is a single column containing employee last name and hire date in the format: last name - mm / yyyy

Consider the data below, which is a single column containing employee last name and hire date in the format: last name-mm/yyyy.
You want to split this into two columns for employee last name and hire date. How would you achieve this?
Group of answer choices
Use Custom Split, using / as the delimiter, and splitting off the first 2 columns.
Use Custom Split, using - as the delimiter, and splitting off the last 1 column.
Use Split and trust that Tableau will automatically detect the delimiter you want.
Use Custom Split, using - as the delimiter, and splitting off the first 2 columns.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!