Solved
Pipeline to add Parent record from child import
I have an App where we are importing standardized data from another source regularly and I have 3 parent tables where the key field is a text field that matches fields in the child table. I am trying...
- One solution is to import to a temporary scratch table. Then have a relationship back to the parents who may or may not exist. But then also have a formula query to detect duplicates and only flag the first duplicate.
Here is one Blog on that.
https://community.quickbase.com/blogs/ashley-banning/2021/07/26/finding-duplicates-in-qb-just-got-easier
The "extension" to your use case would be to hive off the first result form the Formula Query and only import where the [Record ID#] matches the duplicate finder.
------------------------------
Mark Shnier (YQC)
[email protected]
------------------------------
