Batch macro join to previous iterations

[JuniorS]

Hi, 

I am trying to get a macro to join the values onto previous iterations but only using tools that can also be used indb. I do not want to use the transpose tool as it is not indb. How do I get the macro to output as a join of iterations and not a union  using tools that are also indb?

i am using a batch macro set up like :

desired output:

Input looks like :

Current incorrect output:

Thank you

[mceleavey]

Hi @JuniorS ,

The short answer is no. Batch macros will run all batches and output a unioned result.

I would suggest posting some sample data and we can build it in a way that will give you your desired output.

M.

[JuniorS]

Hi, Thanks for the response I have attached a sample data set here 🙂

[SeanAdams]

Hey @JuniorS 

You've mentioned that you want to do this in-DB - this means that you need to do the transpose in SQL.

The SQL equivalent of Transpose is Unpivot - https://codingsight.com/understanding-pivot-unpivot-and-reverse-pivot-statements/

NOTE: Pivot and Unpivot are not supported by all SQL engines, and the syntax differs - so you may decide to do this the easy way in Alteryx using Transpose tool.