Hi All,
New Alteryx user here and struggling mightily to get my data formatted in the way I would like.
I attached the alteryx workflow, can someone please help me convert the data into the excel layout?
Thank you so much in advance for your help.
Anthony
Solved! Go to Solution.
Hey @anthony99, you haven't attached your input or provided a packaged workflow with the asset included, so we can't get the input data when opening your provided workflow. Are you able to provide this so we can have a crack? If it's confidential/sensitive data then feel free to use dummy values. Cheers!
How does this look @anthony99? The headers aren't stacked but other than that seems to look like what you're after.
Thank you so much! Would there be a way to sort the months? My fiscal year starts in Month 9?
Off my laptop and can’t think of an idea instantly off the top of my head but if you just need that report for now then could chuck a select tool on and rearrange columns. Can take a look at a more dynamic solution later if nobody else has!
Hi @anthony99 , Try this workflow I did some mapping to get to the desired result. I hope this helps!
Also, do not forget to mark my post as solution if it helps!
Thanks!
@anthony99 did you get a chance to try my workflow out? Just wanted to know if it is helpful!