Pivot Calculated Fields

Published: 15 Oct 2018
Last modified date: 15 Aug 2023

How to pivot on calculated fields, including split fields

The attached "split then pivot prep flow.tfl" demonstrates the following directions:

Open Tableau Prep and connect to the original data source
Hover over Original Data, click the plus (+), and select Add Step
In Clean 1, right-click the field containing the list of values, this example uses [Pet Name], and select Split Values > Custom Split…
In the Custom Split dialog, do the following:
- Enter the separator, which is ,
- For Split off, select All
- Click Split
Hover over Clean 1, click the plus (+), and select Add Pivot
Drag [Pet Name - Split 1], [Pet Name - Split 2], and [Pet Name - Split 3] to the Pivot1 Values column
Hover over Pivot 1, click the plus (+), and select Add Output
In Output, run the flow

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