Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Alteryx - fixed the column headings

ATC
6 - Meteoroid

I have the data file as below:

ATC_0-1600069051418.png

 

I want the output as below (the header must the in sequence from Jan-Dec, those blank will show 0 value)

ATC_1-1600069123706.png

 

4 REPLIES 4
Ladarthure
14 - Magnetar
14 - Magnetar

Hi @ATC ,

 

would you have some sample data with what you have at the beginning of your workflow?

 

Arthur

Emil_Kos
17 - Castor
17 - Castor

Hi @ATC,

 

Hope it helps.

 

Emil_Kos_0-1600069717533.png

 

If this was helpful for your please mark as solved. 

Thanks!

DavidP
17 - Castor
17 - Castor

Hi @ATC 

 

AN alternative would be to create the headers you want in the correct sequence, then Union that with your dataset.

 

DavidP_0-1600069964923.png

 

ATC
6 - Meteoroid

Thanks a lot, it works!

Labels