i am new to UIpath and is trying to figure out what activities/loop i can use for my scenario. Hope to get some direction so that i proceed
My excel file contains rows with duplicate OrderIDs as 1 OrderID comprises of several ItemIDs that a customer order in a single order.
My job is, based on the excel file, create a order in a web application, and add each of the items that the customer ordered into the single order.
Based on my current knowledge, the “For each” activity reads row by row and i can only create a single order and item if i use this activity.
Am i missing some activity that i could use for my scenario? Thanks. I have attached a sample excel for reference.Sample excel file.xlsx (10.0 KB)