Hello,
I am new to Alteryx. I want to know how to handle Transpose with dynamic columns. Please refer following table for more details.
In the following input data, my date field will be dynamic value in future. At this moment, it looks simple but date fields may increase drastically. It would be difficult to select all dates columns in the transpose tool in future.
How should we handle and show the output?
Attached Sample input and output file
Product | Category | Suggested Age Range | 7/1/2019 | 7/2/2019 | 7/3/2019 | 7/4/2019 | 7/5/2019 |
Graphing Calculators | General | 13+ | 5 | 56 | 5 | 57 | 51 |
Office Supplies | General | All ages | 6 | 232 | 4 | 233 | 228 |
Encyclopedias | Educational | All ages | 7 | 2 | 0 | 3 | 2 |
Building Blocks | Fun and Games | 13+ | 4 | 3 | 4 | 4 | 0 |
Books about Dinosaurs | Fun and Games | All ages | 23 | 5 | 50 | 6 | 4 |
DVDS | Fun and Games | 13+ | 5 | 6 | 2 | 7 | 4 |
Clothing | General | All ages | 54 | 6 | 3 | 7 | 3 |
Frisbee and Frisbee Accessories | Fun and Games | 7+ | 565 | 3 | 6 | 4 | 5 |
Legumes | General | All ages | 23 | 2 | 0 | 3 | 2 |
Microscopes | Educational | 7+ | 23 | 5 | 0 | 6 | 5 |
Solved! Go to Solution.
Pretty simple. Use the Transpose Tool with your Key Fields as those which will not be transposed.
The date fields will be checked along with the Dynamic or Unknown Fields as Data Fields.
WF attached.
Cheers,
Thanks for quick response. It worked