Hi,
I wanted the BOT to filter only to “KR” in Document Type column in the excel.
Then process the 1st unique value in WBS Element column.
After completed, write the status in the SO# column
For example, if the 1st unique WBS element has 1 line, it will write status at SO# column
Then continue 2nd unique WBS element which has 2 lines, it will write the 2 visible SO# column
Thanks for the help !
Attached excel and workflow for your reference.
sample order creation.xlsx (10.8 KB)
Main3.xaml (119.0 KB)