Compare to two excel sheet for required columns only

Help Activities
, ,
1

Hi Team,

Need to compare the required column values from sheet2 to sheet1

Condition: If values do not matched sheet2 values from sheet1 then throw the exception

Sheet1:

An Excel spreadsheet shows a range of data in cells A1 to B4, with numeric codes and identifiers listed under headers "E212" and "E214," highlighted by a green dashed border. (Captioned by AI)
An Excel spreadsheet shows a range of data in cells A1 to B4, with numeric codes and identifiers listed under headers "E212" and "E214," highlighted by a green dashed border. (Captioned by AI)258×127 2.1 KB

Sheet2:

image
image267×124 2.3 KB

please help

thanks
shaik

2

Hi @Mukthar_Valli

Try this workflow if you want to compare only specific columns

This image depicts a workflow in a visual programming environment, where two Excel sheets are read and then compared using a conditional statement to determine if their sequences are equal, throwing an exception if they are not. (Captioned by AI)
This image depicts a workflow in a visual programming environment, where two Excel sheets are read and then compared using a conditional statement to determine if their sequences are equal, throwing an exception if they are not. (Captioned by AI)954×678 32.7 KB


Not Enumerable.SequenceEqual(dt1.DefaultView.ToTable(False,{"Column1","Column2"}).AsEnumerable, dt2.DefaultView.ToTable(False,{"Column1","Column2"}).AsEnumerable, DataRowComparer.Default)

Hope this helps!
Happy automation :innocent:

1 Like
3

my values are equal but it’s going to throw the exception

please check

thanks
shaik

4

Hi @Sanjay_Bhat

Try this condition in If:

If
  dt2.AsEnumerable().Any(Function(row2) Not dt1.AsEnumerable().Select(Function(row1) row1("E212").ToString.Trim()).Contains(row2("E214").ToString.Trim()))
Then
   New Exception("Some values in Sheet2 are not present in Sheet1.")
End If

Hope it helps!!

5

it’s going throw the exception

please check

thank
shaik

6

Hi @Mukthar_Valli

Try this condition in If:

If
 Not dt2.AsEnumerable().All(Function(r2) dt1.AsEnumerable().Any(Function(r1) r1("E212").ToString = r2("E212").ToString AndAlso r1("E214").ToString = r2("E214").ToString))
Then
   New Exception("One or more rows in dt2 not found in dt1.")
End If

Hope it helps!!

7

Thank you @Parvathy logic working fine

1 Like
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.