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
I have two ideas:
Adding another column as keys(like row numbers) to be used instead of the keys you are using.
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.