Error [ Column "pivot1 names" Does Not Exist In xxx ] When There Is A Pivot Step In Flow

KNOWLEDGE BASE

Error [ Column "pivot1 names" Does Not Exist In xxx ] When There Is A Pivot Step In Flow

Published: 13 Mar 2020
Last Modified Date: 22 Apr 2020

Issue

When running a flow containing a pivot step, following error occurs.

Something went wrong and we were unable to process output step:
Failure evaluating to database: [Amazon][Amazon Redshift] (30) Error occurred while trying to execute a query: [SQLState 42703] ERROR: column "pivot1 names" does not exist in xxx
Try running the flow again or review the log file for more details.

Environment

Tableau Prep Builder 2020.1.3 and later versions
Amazon Redshift, PostgreSQL, Teradata and other databases

Resolution

Option 1
Upgrade Tableau Prep Builder to 2020.1.5 or later versions.

Option 2
Downgrade Tableau Prep Builder to 2020.1.2 or previous versions.