Potential Macro Question

[szwgl2022]

Hello,

I have a data shown below. Say there are 6 items in total (some have group# and some don't) and I want to assign them in 3 groups and each group has 2 items. How do I assign group# to the remaining items in the order of group# (1,2,3...) and at the same time in the priority of item ID (assign 2,4,5...)?

The data can be much larger and I may need to assign them to like 20 groups each has 50 items.

[IraWatt · Accepted solution]

Hey @szwgl2022,

Here is an iterative macro set up:

There is some great videos on the community if you want to better understand macros Interactive Lessons - Alteryx Community.

Any questions or issues please ask :)
HTH!
Ira

[szwgl2022]

Thanks a lot! This is exactly what I need! 

[szwgl2022]

One clarification is that the "Number of Groups" you added in the Macro interface actually means the number of items/members in each group not the total group numbers, right?

[IraWatt]

@szwgl2022 Ah yes it means the number of items, badly labelled from me there 😅.