Hello,
I'm new to Alteryx and never used iterative macro before, but I think the macro can help me streamline the below process and I hope someone can help me on creating such macro.
So basically I have some sample data below and my current workflow has to filter by Map Column multiple times then transpose the filtered data and finally join all transposed data together.
I think an iterative macro can save tons of time instead of manually filter - transpose - join, or some other method can simplify the workflow.
The desired output is something like this:
I hope my description makes sense. I have been struggling on this for a couple days so I really appreciate someone could help out with a solution.
Thank you very much.
Blake
Solved! Go to Solution.
Hi @hyan028,
Looks like you just need to use a combination of the Transpose and Cross Tab Tools.
First Transpose with 'map' as a 'key field' and 'AAA', 'BBB',... as the 'data field'. Then send that into a Cross tab tool, grouping by 'Name' with 'map' as new column headers and 'Value' as Values for New Columns. See images below.
Hope this helps,
MSalvage
Thanks @MSalvage, that indeed get the same results, which is perfect!