Hello,
I want to compare two excel sheets, and want only those row values who’s one column ( ex . Sheet 1 Column - " INV NO. " ) and Sheet 2 Column - " GST Invoice Number " ) values are same.
Output - only those row Values whose column values are same and farther enter those values in SAP Application.
→ x(0), 0 represents column index of sheet1, please change this accordingly or give column name Ex: x(“PartNumber”). Same applies to y(0) but here 0 represents the column index of Sheet2
Hello @Ajinya_jorwekar ,
You can read the Two Excel sheets using two Read range workbook activities and store the data in 2 data tables and use the join datatable activity. The screenshot of the join dataTable condition is given below:
I hope this helps you, If you have any query , do contact.
Regards;)
It is not giving me expected output,
Actually I want the values of “sheet 1” whose column (INV NO.) values are matching with column (GST Invoice Number)“ZEX34 table” Sheet
Hello @Ajinya_jorwekar ,
This error is occured because in your assign activity, the Source dataTable that you have used ‘dt1’ does not contain any data Row.