Compare two excels and remove duplicates from it

Help
, , ,
1

Hello!

I have two excels having same columns and some duplicate data. for ex:
excel1: column1,column2,column3
A,B,22/12/2019
C,D,23/12/2019
excel2: Column1,Column2,Column3
A,E,22/12/2019
C,D,23/12/2019
Output excel: Column1, Column2,Column3
A,E,22/12/2019
By comparing excel1 and excel2 i found one duplicate. so output should be without duplicate and the value should be taken from excel2 not from excel1.(ie, excel1 : A,B,22/12/2019 is not a duplicate but it should not be taken in output excel only the output of excel 2: A,E,22/12/2019 need to take)

2

Can you share the two input excel and the output excel that you want to achieve ? @mani93

cheers :smiley:

Happy learning :smiley:

3

@mani93

Use Join DataTable activity to do this.

4

Input.xlsx (9.0 KB) Old data.xlsx (8.4 KB) output.xlsx (8.8 KB)

@pattyricarte for your reference i created dummy data having 3 excels as “old data” which is already having past data in it. “Input” which is a new sheet having new data. after comparison the output should be stored in “output”

5

Great I will check it @mani93

cheers :smiley:

Happy learning :smiley:

6

Hi @mani93
i have check your excel file and i saw interesting article for your issue.

You can follow this article for your reference.

cheers :smiley:

Happy learning:D

7

Hi @pattyricarte
Sure Thank you:smiley:

8

No worries @mani93

Happy to help here !

cheers :smiley:
Happy learning :smiley:

9

I should appreciate you for the way you respond especially Happy learning good to see this.
Great job @pattyricarte

10

@pattyricarte Wow its working great. Thank you soo much :grinning:

11

Yey great to know that it works.

cheers