Unable to Pivot Columns in Hyper Data Sources With Tableau Desktop
Published: 03 Jul 2020 Last Modified Date: 03 Jul 2020
Issue
Unable to pivot data columns when connect to a hyper file directly from Tableau Desktop.
Environment
Tableau Desktop 2020.2
Resolution
Workaround:
1. Export data from hyper file to csv file ※Please refer to the following online help for detailed export steps Export your data to .csv file
2. Connect to csv file again and pivot the column.
Cause
The ability to pivot data columns from data sources besides Microsoft Excel, text file, Google Sheets, and .pdf data sources is not built into the product at this point. Pivot Data from Columns to Rows
Thank you for providing your feedback on the effectiveness of the article.