How to compare two sheet value and get the output in another excel file?

Help Studio
, , ,
1

I have two input sheets (i.e) Sheet1 & Sheet2.

From the sheet2 table , I have to take “Material” column values (i.e) “ADC Group” and match that values with “Company name” column value from Sheet1 , If it is matched i have to take the corresponding match row values from the sheet 1 & update into the output excel file based on the headers which is already available in the excel file.

Note: The Sheet2 have 3 rows, So Each rows needs to check & update into the output Excel file.

Please refer output sheet values.

How to do this, Can someone Guide me on this please?

Sample Input & Output.xlsx (13.4 KB)

2

@jamuna_T

this looks like a join datatable case

try to read both the sheets into tables and then use join datatable

after that you can delete the unwanted columns using filter datatable

cheers

1 Like
3

Thanks for the Response @Anil_G

Could you please provide any xaml file please.
Thanks!!