Forum Discussion

AishwaryaJinde1's avatar
AishwaryaJinde1
Qrew Member
4 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's avatar
MattHardy
Qrew Trainee
4 years ago
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
------------------------------