Alteryx Designer Desktop Discussions

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

How can I change my Fiscal Month column to their own individual columns

KVlahovljak
7 - Meteor

Hi I keep trying to get my months into their own columns but everything i have tried is not working. Here is a example of what I am trying to accomplish. I am trying to keep the months in order from July, August, and so on...

 

KVlahovljak_0-1598393191689.png

 

4 REPLIES 4
paulfound
11 - Bolide

Hi @KVlahovljak 

 

PaulFound_0-1598420274289.png

Here is a solution I think will work.

 

if take month name turns it into a date, then pivots and dynamically renames back to just month name.

 

Hope it helps, let me know.  

KVlahovljak
7 - Meteor

Hi!! Thank you so much for your help! I can not seem to get my months back in the specific order I need them in?   I tried adding reordering the tools to no avail.  I am trying to get them in order from July to July if that makes sense? 

paulfound
11 - Bolide

Here is another idea using arrange tool. 

 

PaulFound_0-1598466537532.png

 

had to change your grouping to.

KVlahovljak
7 - Meteor

This is exactly what i had trouble doing, thank you so much!!  

Labels