Hi, I need to crosscheck two Excel files and then return the output below: Excel 1: [image] Excel 2: [image] Desired Output 1: [image] Desired output 2: [image] I already did the first part. I need to do the second part now. Please find attached the project and the data below. Thanks! C…

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…

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!

Crosschecking two excel files and then separating

Help Activities

Gayathri_Ramanathan (Gayathri Ramanathan) November 30, 2023, 10:52am 4

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)

1 Like

Topic		Replies	Views
Crosscheck 2 excel fiels and output Activities datatable , excel , uiautomation , activities , studio , question , activities_panel	12	399	December 1, 2023
Comparing 2 excel files and making a new excel file with the results Activities datatable , excel , studio , question	2	924	October 8, 2020
Please help to compare excel files Activities excel	19	1518	January 28, 2021
Differences between two files Help excel	1	757	September 21, 2019
How can i compare 2 excel file and if there is a difference write it on an other excel file Activities excel , question	42	755	August 23, 2023

Crosschecking two excel files and then separating

Related topics