A client is working in Tableau Prep and has a field named Orderld that is compiled by country, year, and an order number as shown in the following table.
What should the consultant use to transform the table in the most efficient manner?
To transform theOrderldfield in Tableau Prep, the Split option is the most efficient and straightforward method. Here’s how you can apply it:
In Tableau Prep, drag your dataset into the flow.
Click on theOrderldfield in the workspace to select it.
Look for the option in the toolbar that says "Split" and select it.
Choose "Automatic Split" if the delimiters (such as hyphens) are consistent; Tableau Prep should automatically detect the hyphen as the delimiter and split theOrderldinto multiple new fields.
The dataset should now show new columns: one for the country code (CA, FR, US), one for the year (2017), and one for the order number (152156, 152157, etc.).
The Split option works effectively here because it automatically identifies and uses the hyphen as the delimiter to divide the originalOrderldinto the desired components without manual specification of conditions or writing any formulas.
ReferencesThis procedure is based on the standard functionalities provided in Tableau Prep for splitting a field into multiple columns based on a delimiter, as described in the Tableau Prep user guide.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit