Pivot Results in Outout File Do Not Match with Results Being Displayed in Tableau Prep Builder

Published: 17 Feb 2020
Last Modified Date: 17 Feb 2020


When using row to column pivot to clean a file, the result in the CSV output file does not match the result displayed in Tableau Prep Builder 2019.4.2 or 2020.1.1.

Additionally, this issue occurs when the flow includes clean steps such as renaming a column with the name of a deleted column.


    Tableau Prep Builder 2019.4.2, 2020.1.1


    Try one of the following workarounds:
    1. Use Tableau Prep Builder 2019.2.3 or 2019.3.2 if you need to name a column with the name of a deleted column when cleaning your data (before the pivot step.)
    2. Or, avoid naming a column with the name of a deleted column while cleaning your data (before the pivot step.)


    This issue (issue ID 1049181) is currently under investigation.
    Did this article resolve the issue?