Hi Alteryx engineer,
My case is i will use batch macro to pass date to create dataset, and the dataset is return by macro output,
i want to join or union the dataset return by each iteration. how can I implement it?
@aeolus187 can you provide a sample/screenshot of your exact inputs and expected outputs? I'd imagine it's certainly possible but hard to know which approach to take without seeing the schema etc.
If your data is sensitive then a dummy will do.
I've attached a potential solution, depending on whether or not your iteration outputs are similar to how I assume they may look.
For batch macros you can union your macro outputs. In the interface designer (Ctrl+Alt+D), you can change the union (in the properties tab) and set your results to union based on field names/position etc depending on the requirement.
For a more detailed response, are you able to provide any extra info about outputs? Perhaps some screenshots/sample data so we can help you find the best solution.
@aeolus187 I believe by design, the results coming out from a batch macro will be "union" together.
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/ta-p/488165
@DataNath yup i see Union works for that, what if i want the dataset append, how can i implement this? I want to join the dataset in position
@Qiu
yup you are right, what if i want to join the each iteration dataset like below?
yup this is my workflow and here is my expected result looks like
If each unioned result has a unique identifier throughout then you could add the solution in my last reply to your macro output, grouping by that in your multi-row and then using that for your headers in the cross tab.
@DataNath
i got the way to get it done, thanks for your solution
