community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

Learn More
SOLVED

Transpose - Dynamic columns

Meteoroid

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

 

ProductCategorySuggested Age Range7/1/20197/2/20197/3/20197/4/20197/5/2019
Graphing CalculatorsGeneral13+55655751
Office SuppliesGeneralAll ages62324233228
EncyclopediasEducationalAll ages72032
Building BlocksFun and Games13+43440
Books about DinosaursFun and GamesAll ages2355064
DVDSFun and Games13+56274
ClothingGeneralAll ages546373
Frisbee and Frisbee AccessoriesFun and Games7+5653645
LegumesGeneralAll ages232032
MicroscopesEducational7+235065
Alteryx Certified Partner
Alteryx Certified Partner

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.

 

snap.PNG

 

WF attached.

 

Cheers,

Highlighted
Meteoroid

Thanks for quick response. It worked

Labels