Last Modified Date: 14 Jul 2020
Environment
- Tableau Prep Builder
Answer
1. Connect to data source "datasource.xlsx".2. Drag table to Flow Pane
3. Add a step Pivot
4. Drag the columns num0 ~ num10 to Pivot Fields
5. Add a step Aggregate
6. Add other columns (No, Category, Name) in Grouped Fields
7. Add num to Aggregated Fields
8. Add a step Clean Step, to check the results
9. Add an output
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials