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
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
The record could be imported to a temporary scratch table. Then us a formula query to detect duplicates and only flag the 1st "duplicate" as good to import.

When I get a chance I will post a link to how to detect duplicates.


------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------