Crosschecking two excel files and then separating

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

Hi,

I need to crosscheck two Excel files and then return the output below:

Excel 1:

Excel 2:

Desired Output 1:

Desired output 2:

I already did the first part. I need to do the second part now. Please find attached the project and the data below.
Thanks!
CompareExcelFile.zip (20.3 KB)

[fernando_zuluaga]

Hi @Yudhisteer_Chintaram1

you can get the result you want using the following code, however you will need to rename the result column and then replace the values in the second column for the one that you need, in your case “To be check” do this within a for each row activity

dt_Excel1.AsEnumerable().Where(Function(row) Not dt_Excel2.AsEnumerable().Select(Function(r) r(0).ToString).Any(Function(x) x = row(0).ToString)).CopyToDataTable()

Regards!

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

When I am doing the join the output is not good. Also I need to separate excel files.
@fernando_zuluaga

@prasath17 Can you help please?
Thank you!

[Gayathri_Ramanathan]

Hi @Yudhisteer_Chintaram1

Please find the attached solution. You can modify the column names and add or remove extra columns according to your requirement.

CompareExcelFile.zip (25.3 KB)