Removing the old month data in new1 excel sheet

Help Studio
1

Hi
I have 2 file old month data is New.xl . Current month file name is New1.xl
In the current month file i have the old month files also. I need to compare both files and remove the old month data in current month sheet
In that file 3 rows are there
New1.xlsx (11.0 KB)
NEW.xlsx (9.2 KB)
I attached both file here
The final result are in OP sheet in New1 file

2

HI,

Can you try the following sample?

image
image767×560 22.9 KB 

cuurentDt.AsEnumerable.Except(previousDt.AsEnumerable,DataRowComparer.Default).CopyToDataTable

Sample20230515-3L.zip (17.2 KB)

Regards,

1 Like
3

I try this method, here in result. Xlsx file has the old data, but i want the new data

4

HI,

Sorry but can you elaborate?

Your OP sheet is your expected result, isn’t it? The output of the above samepl is same as OP sheet, as the following.

image
image886×746 35.9 KB

Regards,

5

This is the output i got

IMG_20230515_132625.jpg
IMG_20230515_132625.jpg3072×4080 3.14 MB

6

HI,

Did you try the above sample as it is? Or modified data etc?

Regards,

7

Above one only. Just run the xml file that u send

8

Hi,

It seems strange…
Can you share your current project which outputs the above result?

Regards,

9

Sorry i found the correct result, I choose wrong input file so only the result is not correct