Compare two excels and remove duplicates from it

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)

3 Likes

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

cheers :smiley:

Happy learning :smiley:

3 Likes

@mani93

Use Join DataTable activity to do this.

5 Likes

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”

2 Likes

Great I will check it @mani93

cheers :smiley:

Happy learning :smiley:

3 Likes

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

5 Likes

Hi @pattyricarte
Sure Thank you:smiley:

3 Likes

No worries @mani93

Happy to help here !

cheers :smiley:
Happy learning :smiley:

3 Likes

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

1 Like

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

2 Likes

Yey great to know that it works.

cheers

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.