Batch Macro Advice

[josiahgoh]

Hi, i have raised a previous issue:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Iterative-Macro-Help/m-p/12560...

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.

[Raj]

@josiahgoh 
i see that it is marked as done on the link?

[josiahgoh]

@Raj hi raj, it was completed for a different issue. This new post is an enhancement based on the previous issue.

[Raj]

@josiahgoh got confused by question title "Follow up"
my bad.

[josiahgoh]

@Raj no worries. I have edited it. Hope to seek some advice from you or others in the community.

[Raj · Accepted solution]

@josiahgoh 
Macro updated this will work dynamically

Please like and mark done if works for you>

[josiahgoh]

Awesome, this works thanks!