Compared two sheets and get data

Help Studio
,
1

Compare input 1 file 1 St column and Input 2 file 1 St column if
Input 2.xlsx (6.4 KB)
Input 1.xlsx (6.7 KB)
output.xlsx (7.5 KB)
he data is match put Y in input file 2 column of input 1 file , i attached the excel file also

2

@Aarthy1

Please follow the steps

  1. Read the input1 into datatable(dt)
  2. For each row in excel on input2
  3. Use filter datatable and filter dt1 with currentrow(0).tostring
  4. If filtereddt.rowcount>0 then use assign currentrow(1) = “Y”

Cheers