Loading

Pivot Calculated Fields

Data pubblicazione: Apr 30, 2025
Operazione
How to pivot on calculated fields, including split fields
Fasi
The attached "split then pivot prep flow.tfl" demonstrates the following directions:
  1. Open Tableau Prep and connect to the original data source
  2. Hover over Original Data, click the plus (+), and select Add Step
  3. In Clean 1, right-click the field containing the list of values, this example uses [Pet Name], and select Split Values > Custom Split…
  4. In the Custom Split dialog, do the following:
    • Enter the separator, which is ,
    • For Split off, select All
    • Click Split
  5. Hover over Clean 1, click the plus (+), and select Add Pivot
  6. Drag [Pet Name - Split 1], [Pet Name - Split 2], and [Pet Name - Split 3] to the Pivot1 Values column
  7. Hover over Pivot 1, click the plus (+), and select Add Output
  8. In Output, run the flow
Risorse aggiuntive
The ability to pivot on calculated fields is only included in Tableau Prep. If it is not possible to use Tableau Prep, then it may still be possible to build the desired view without pivoting the calculated fields. See Creating Views When Data is Formatted as Text Lists.

Clean and Shape Data in Tableau Prep
Creating Views When Data is Formatted as Text Lists
Numero articolo Knowledge

001453821

Allegati

string to split.xlsx

9 KB

split then pivot prep flow.tfl

2 KB

 
Caricamento
Salesforce Help | Article