Use Iterative Macro To Join Transposed Data

hyan028

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

MSalvage

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