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.
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.
Use select statement or use filterdata table and pass the result as a argument
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) +"’