Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Driven Web Sites

Authors: Joline Morrison, Mike Morrison

2nd Edition

? 061906448X, 978-0619064488

More Books

Students also viewed these Databases questions

Question

Identify tax research goals.

Answered: 1 week ago

Question

Explain the pages in white the expert taxes

Answered: 1 week ago