Forum Discussion

Qrew Member

3 years ago

Check for unique records and import them while reject others in bulk import

Hello team, I have a table called Products. Here, there is a column called Supplier-Product number which is formula field and I have made it unique according to the requirement. When I am bulk ...

Data import and export

Pipelines

MattHardy

Qrew Trainee

Could you create a copy of the table without the unique requirement, import into that, then run a pipeline to copy the data to the working table? The pipeline will fail on each of the non-unique records, but will continue on all unique. Then use the same pipeline to remove all records from the import table

------------------------------
Matt Hardy
------------------------------

AishwaryaJinde1

Qrew Member

3 years ago

Hello Matt, this solution works great. Thank you!

Above you have said that using the same pipeline to remove all records from the import table
Here, the import table refers to the copy table where the unique property is not present, right?

------------------------------
Aishwarya Jinde
------------------------------