Compare 2 excel sheets

Help
, ,
1

I am trying to compare to excel sheets. Let me explain it with brief scenario:

Assume I have 2 excel sheets A and B.
I want to compare first column of both the sheets. I stored both the excel sheet into datatables dt_A and dt_B. Now I am having a foreach loop for dt_A and under body I have LookUpDatatable for dt_B. After wards I am comparing if the cell value is null, I am using a Add row item to add the row in dt_A to another datatable let’s say dt_C.

But I am getting an error Object reference not set to instance of object.

Can you please help me with this.

Thanks in advance.

2

use build data table activity in start and get output like dt_C and pass this output in Add data row
cheers @sushantk

3

I am trying to use add data row activity but I am getting error Object reference not set to instance of object. @Pradeep_Shiv

4

can i see your workflow?

5

Yeah sure. Actually I am in my office. Will send the workflow by EOD with details

6

Hi @Pradeep_Shiv,

Please find workflow attached with this mail.Compare Excel.7z (23.7 KB)