Discussions

Expand all | Collapse all

Find and append new unique values to secondary table

  • 1.  Find and append new unique values to secondary table

    Posted 12-14-2017 21:29
    I have an app where I run a daily upload of data (much of it duplicate due to the nature of the source), but sometimes my daily upload includes a new record that needs to be added to a secondary table within the app. The key field in the secondary table matches one of the fields in my daily upload. I have set up a QB action that should identify new unique values in the field related to the secondary table's key and copy these records. But I am running into a problem. Sometimes my upload will include several rows with the same value in the field that I want to use to populate the secondary table's key field . When this happens, my action is registering an error. I only need the value in one of the duplicate lines to write to the secondary table, but I need to preserve all of the lines in the primary table. Any suggestions?


  • 2.  RE: Find and append new unique values to secondary table

    Top
    Contributor
    Posted 02-16-2018 22:22
    If you have the ability, I'd use a webhook to a script that will query the table, and then do a single import based on a the combined information, thus limiting the duplicates.