Forum Discussion

AishwaryaJinde1's avatar
AishwaryaJinde1
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's avatar
MattHardy
Qrew Trainee
3 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
------------------------------
  • AishwaryaJinde1's avatar
    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
    ------------------------------