assigning records to different IDs in Alteryx

[Bharath]

Hi ,

I have 15480 records in total. I need to assign the 1st 215 records to ID 1 ,next 215 records to ID 2, next 215 records to ID 3, likewise I need to assign 215 records for seperate ID upto 72.. how to do this in Alteryx quickly?

[MarqueeCrew]

you can add a record id to every record. Then use a formula like:

Floor(RecordID/215)+1

See if that works for you.

Thanks,
Mark