Hi guys
I'm having some problems with using Macro Input and Batch macro at the same time.
I wanna build a macro that will read the XML data which is concatenated in one row as the Macro Input, and then parse the XML data with all the child names from a list by using a Control Param.
However, the result is just blank. Has anyone faced this issues ? How can I make the Batch macro works for the Macro input ?
Expected output:
Solved! Go to Solution.
Hi @khoicorn
I dont know why that approach is working. I did some trial and error and have now built a working model.
Workflow:
Macro:
I am using tranpose tool to generalize the name columns. PS: auto config by position didn't work.
Hope this helps : )
Amazing ! It works like magic. Thank you so much.
How it's working with this configuration is still a mystery for me though 🙂
Hi @khoicorn
I can answer on that. Groupby is only required when the groupby column is present both in input data and batch info data. And same columns should be selected from both source in the above config. In this scenario you don't have groupby column in input data hence its should not be used.
Hope this helps : )
User | Count |
---|---|
108 | |
89 | |
78 | |
54 | |
40 |