Solved Removing Duplicates

[kumarsiva]

Hi

Please some one suggest how to remove duplicates from three excel sheets? I have tried by appending all three collections into one collection and use using loops, but for better performance need code to write using C# . Please suggest C# code to remove duplicates.

Thank You

 

[cs.andras]

Hi

Please some one suggest how to remove duplicates from three excel sheets? I have tried by appending all three collections into one collection and use using loops, but for better performance need code to write using C# . Please suggest C# code to remove duplicates.

Thank You

Hi,
The fastest in my opinion would be to merge the 3 excels and remove duplicates there. If you need the 3 files to remain separate, then of course this version won't work for you. Otherwise it'd be quite fast.
Regards,
Andras

 

[VJR]

Hi @kumarsiva,

Here is some C# code from @arodriguezm which can be helpful to utilise on the collections you have taken.

https://rpaforum.net/threads/how-to-compare-two-excel-sheet-using-c-code-in-blueprism.897/#post-2510

 

[kumarsiva]

Thank You a Lot @VJR @cs.andras