How to remove/avoid duplicate data in Spreadsheet

Confluence User - 14 Dec, 2020

I have one spreadsheet to insert data into database, the primary key {id} is created by SQL. But I want to remove/avoid duplicate data in Spreadsheet. Because the id is different, other column is the same also can be insert successfully. The same record should be removed obviously. 

forms;datalists

2


17 Dec, 2020
confluenceUser
confluenceUser

Hi, if the primary key ID is created automatically, then how would you know whether data is duplicate or not? If you want to avoid such duplicates then I do not think you can use auto-generated IDs.

27 Dec, 2020
confluenceUser
confluenceUser

Thanks for this such an excellent post! Keep up! bad love story

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print