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

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

Example.yxzp