How to loop through column keeping the row constant


#1

Hi ,
I need to automate an excel containing 3 columns with 100 rows . The first column contains plant names (ex. AST5,AST6) nd second column contains storage locations to be created for each plant (ex.0001,0002,… etc) how do I create only storage locations for a single plant and continue to loop for next Plant
PLANT LOC DECP
AST5 0001 NEW
AST5 0002 NEW
AST5 0003 NEW
AST6 0001 NEW
AST6 0002 NEW

Regards


#2

Hi @Ramyavij

https://forum.uipath.com/t/foreach-column/3030

Check this link ,you can get some insight about iterating column values.

Regards,
Ranjith.