Import data duplicate problem

[Sayad]

I have imported many duplicate data in my import data. I want that duplicate data should not be imported. Its possible. please suggest me. how can do that.

[graham_howe]

How are you importing the data, is it through a file upload into AppSheet or is this duplicate data which is found in your source? What is the source you are using? I wouldn't necessarily see AppSheet as the best option for deduplicating data, especially if it is a large dataset, it would be better to clean the data before importing. However if you need to extract unique items from a list in AppSheet then you can use UNIQUE() | AppSheet Help Center 

[Steve]

Import the data into a separate table that exists solely to receive imports. One imported there, use a bot to copy the appropriate data into your live table.

[Sayad]

Hi @Steve @graham_howe 

Some data gets updated and some gets inserted. But many data duplicates also get inserted. I want that my data sheet should not be imported into my data sheet. How can I prevent duplicate imports? Tell me

[Steve]

I did.

You're awfully demanding.