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.
 

Cause

This is a known issue fixed in the above Tableau Prep Builder version.
Did this article resolve the issue?