0 Reports
"[SQLSTATE:42P21] collation mismatch between explicitly provided collations" Error When Running Flow using Union Step Combining Multiple Excel Sheets
Created
Found in Release
2024.3 and older
Last Updated
Reference ID
W-17872999
Summary
In Tableau Prep Builder, running a flow using a union step combining multiple Excel sheets results in a collation mismatch error.
Error Details
Steps to Reproduce
- Create a Flow in Tableau Prep Builder connecting to Excel, using multiple Excel worksheets. In testing, five (5) sheets were used.
- Add a Union step in the Flow to combine the Excel sheets.
- Please see Union Your Data for more information.
- Create the remainder of the Flow as desired, including an Output step.
- Attempt to run the Flow.
- The error appears.
Workaround
- Create a copy of the generated output file (Using a different file name, as Prep does not allow to use the same output file name as the input).
- From connection menu, choose to add a Tableau Extract File and use the copy file of generated output from step 1.
- Break down the flow into two separate flow files using the input file from step 2 as input for the latter part of the flow.
- Once the flow steps are split into two, the flow runs without issue.
Reference IDW-17872999
0 Reports