KNOWLEDGE BASE

[System error: null] Occurs When Pivot from [Rows to Columns] in Tableau Prep


Published: 19 Jan 2022
Last Modified Date: 23 Jan 2022

Issue

[System error: null] when pivoting from [Rows to Columns] in Tableau Prep like the image below.

User-added image


The expected output should be:

User-added image

Environment

  • Tableau Prep Builder 2021.4.3
  • Tableau Prep Builder 2021.3.3

Resolution

Please consider the following workarounds to avoid this issue.

Option 1:

Use Tableau Prep Builder 2021.2.3.

Option 2: 

Add a third column before the Pivot step and the Pivot step should work as expected.
User-added image

User-added image

Also, check the attached Flow file for details.

Cause

This issue is still under investigation by ISSUE ID: 1363806

Additional Information

This issue only happened when there are only 2 columns and using [Rows to Columns].
Did this article resolve the issue?