How to navigate the excel data with the help of same value

i want to give this excel sheet as a input to the purchase order but it has multiple vendors and items so i want to give the value when same vendor id match regarding the action. please share your thoughts. Thanks in advance.

Read this Excel, pass the datatable as argument loop through each row(for each row) check the value if(VendorID==‘Your variable/Constant’) then continue the process else part will be empty.

1 Like

thanks for your reply. I want to group the data with respectively vendorID and action because i need to give this grouped data to the various Purchase order input like creating, updating.

@Prakash_Raj using select statement on dataTable u can get particular vendorID rows.

1 Like

Use select statement or use filterdata table and pass the result as a argument

1 Like

How to use select statement and filter table in excel any examples pls… @Divyashreem

vendorID can be generate dynamically how to do that… @Manjuts90

@Prakash_Raj use read column activity to get values from VendorID coulmn.

(DataTableName).Select(“convert([VendorID], ‘System.String’) = '” + (Variable.ToString/Constant.ToString) +"’