Hi, i have raised a previous issue:
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Iterative-Macro-Help/m-p/1256074/emcs_t/S2h8ZW1haWx8YWNjZXB0X2FzX3NvbHV0aW9uX3JlbWluZGVyfExVR01NS0JLVkZCMENYfDEyNTYwNzR8T1RIRVJTfGhL
and i realise i have to enhance it based on the following scenario:
i have the following dataset in the picture attached, where i need to transform the records into the following output as attached, group by the different categories, where each category has different number of line items.
I would like to make the workflow dynamic so that each category has its own template and can process different number of line items, showing different number of L rows.
I would like to ask how can i make use of a batch macro to do that. I have attached a workflow for reference.
Kindly seek your advice on this. Thank you.
@josiahgoh Macro updated this will work dynamicallyPlease like and mark done if works for you>
@josiahgoh i see that it is marked as done on the link?
@Raj hi raj, it was completed for a different issue. This new post is an enhancement based on the previous issue.
@josiahgoh got confused by question title "Follow up"my bad.
@Raj no worries. I have edited it. Hope to seek some advice from you or others in the community.
Awesome, this works thanks!
