Excel Import Duplicate value issue

0
Hi Experts,   I am going to import 8000 records via excel import, and approximately 1000 of them are duplicates. We are utilising associations for this, and we are required to provide a key. However, after importing, 1000 records are being removed, but I require the 1000 records as well.Is there a way to fix this?   Regards, Rasik.N
asked
1 answers
0

Hi Mohamed,

 

I have two ideas:

 

  1. Adding another column as keys(like row numbers) to be used instead of the keys you are using.
  2. Using before commit microflow to check if a copy already exists and handle it from there(not sure if it applies to this case, never tried it myself).

I think second one is cleaner in terms of implementation but it might not work. First one will work for sure if you are allowed to alter with the file.

 

Cheers.

answered