KNOWLEDGE BASE

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

Issue

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.

    Environment

    Tableau Prep Builder 2019.4.2, 2020.1.1

    Resolution

    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.)

    Cause

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