We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Column ordering in a particular format

DataPirate26
10 - Fireball

Hi all,

Can someone assist me to achieve the required format provided in the Workflow. I need to Group by the BU and then Second Column shall have the Position wise Data and Months will be Sort in the Ascending order Position Wise. 

 

Workflow Attached Below

3 REPLIES 3
DataPirate26
10 - Fireball

Required output format is not the Exact Output which is for the input I have shared but the structure or pattern shall follow the same format. 

cjaneczko
13 - Pulsar

Is this what you are looking to do? The data in your desired output does not show up anywhere in your inputs. I didnt see any Directors listed.

 

cjaneczko_0-1687453355036.png

 

cjaneczko_0-1687453501519.png

 

 

DataPirate26
10 - Fireball

I actually have achieved this already realised that for all months they don't have count so the month column was not sorting . Yes the input doesn't have the Director Data. The output structure was what I was looking into. It is fine. Thank you for your quick response. 

Labels
Top Solution Authors