How to compare two columns and find missing data in Excel

Learning & Development Programs Automation Starter
, ,
3

Hello @Zaw_Win_Htun1

After Reading the Data from Excel use an Assign activity and use the below LinQ to get the Miss-Matched Records from it.

MissMatchDT = (From row In DT1.AsEnumerable
Where(Not row(“PDF Data”).ToString.Trim.Equals(row(“Robot Data”).ToString.Trim))
Select row).CopyToDataTable

image

Hope it helps, However if you’re looking for something else let us know.

Regards,
Rohith

1 Like