Transpose - Dynamic columns

[pawan_bagdiya]

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

[Thableaus · Accepted solution]

Hi @pawan_bagdiya 

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,

[pawan_bagdiya]

Thanks for quick response. It worked