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.