Need to Identify by number the Component Material for each Bundle Material

latimo1

Bundle Material	Count	Right_Bundle Material	Component Material	Order
PURY-P336YSLMU-A-KIT	2	PURY-P336YSLMU-A-KIT	CMY-ER200CBK	1
PURY-P336YSLMU-A-KIT	2	PURY-P336YSLMU-A-KIT	PURY-P168YLMU-A	2

I can't figure out how to generate the Order Number.

TIA! John!

alexnajm

RecordID tool will do the trick! You can even group on the Bundle Material if you need the count to restart back to 1 after each unique material.

 Record ID Tool