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
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.
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.