Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Re arrange month wise rows

areeba
8 - Asteroid

Hi ,

 

I want to re arrange column 'Name2' according to month wise like from Jan to dec and rest 2 columns respectively.

areeba_1-1637076306097.png

Can somebody help?

 

Regards

Areeba

 

3 REPLIES 3
afv2688
16 - Nebula
16 - Nebula

Hello @areeba ,

 

you can use the following formula to transform the mont into a numeric value to then sort afterwards:

 

DateTimeMonth(DateTimeParse([Name2],'%b'))

 

Untitled.png

 

Regards

areeba
8 - Asteroid

Hi @afv2688 

 

Thank you for the solution but my final output should look exact like this:

 

areeba_0-1637077611185.png

 

note: Please ignore decimals in Jul values.

 

Can you help ?

Areeba

 

areeba
8 - Asteroid

Hi @afv2688 

Thanks , it worked. 🙂

Please ignore my above post.

 

Thanks

Areeba

Labels
Top Solution Authors