Removing duplicate records

0
Hello everyone, I have imported one excel sheet using excel import module….the data was retrieved from the excel sheet correctly. But the problem is that im getting the duplicate records when i was taking one particular field from excel and putting that field in the masterdata. Could you please provide any solution for this. Thanks in advance, Apurupa
asked
2 answers
0

A way to prevent this in the future would be to use a “find or create” microflow, something like this:

For your current issue, if the duplicate records are identical, it should be possible to write a fix flow that removes any duplicates, for instance:

  • Retrieve all records
  • For each record, check if it's the only one with its unique key (assuming they have one)
  • If not, add them to a list of items to delete and remove them from the list you're iterating over
  • After the loop completes, delete the list of items to be deleted
answered
0

 

Here i need to remove the duplicate records..how could i do that?

answered