Comparing the excel sheets in different datatable

Help
, , ,
25

image
image1920×1080 224 KB
is my output,i dont know why it is taking the rows like this it should take one to one like i have 4 rows in one excel and 4 rows in another excel and it should compare

1 Like
26

Main.xaml (16.1 KB) my workflow check this one plz

1 Like
27

where the writerange is placed? Is that acitivity inside the loop?

1 Like
28

This is because you’re using one for each row in another for eact row.

1 Like
29

i can separate them and use for comparing

1 Like
30

try to change the Add DataRow activity outside the 2nd loop.

1 Like
31

i did it but same output

1 Like
32

image
image1920×1080 203 KB
it changed to it

1 Like
33

after placing the add data row outside second loop @kalees9486

1 Like
34

Main.xaml (17.3 KB) img.xlsx (8.7 KB) match.xlsx (8.6 KB)

image
image1920×1080 190 KB
this is my output in total2 column i am getting wrong column values can anyone help me in solving these @Dave @Kalees9486 @samir

1 Like
35

Hi @Manisha541

In the if statement please check the invoice number also matched instead of total, because same amount may repeat.
just like this

row1("Total").ToString = row2("Total").ToString & (row1("invoice").toString = row2("invoice").ToString)

Try the above line

1 Like
36

thanks @anoopap for helping me but there is no change in output after replacing the above line

1 Like
37

Hi @Manisha541

Hope this will work
Main.xaml (10.4 KB)

1 Like
38

it worked but i dont want to overwrite in same datatable img dt i want it in new data table with compared columns and output@anoopap

1 Like
39

@Manisha541
Build a new datatable and use add data row just like you did in the existing workflow.

1 Like
40

Hey @Manisha541,

Try this,
Match.zip (26.1 KB)

1 Like
41

image the result excel is empty values

1 Like
43

Hi @Manisha541

I think it will help

Main.xaml (11.7 KB)

Enjoy :grinning:

44

I think its correct only or how do you want the output? @Manisha541

45

Thank you @anoopap @Kalees9486 for your continuous support in helping me to solve my issues in the workflow,thanks a lot:blush:

1 Like