Skip to content

    • Archive

    Archive

    MySQL query structure for merge update feature

    Member
    in Archive

    We are trying to implement the merge  update mode in domo (aka upsert), but I cannot find any documentation regarding how to implement it. Especially with regard to the query structure required to make it work. I understand that we need to identify merge key in our datasets and use them in a WHERE statement, but it still does not work. What am I doing wrong? Thanks! 

    Comments

    • Member

      Hi,

      Is anyone able to help out with this request?


      Thanks,

    • Contributor

      Hi,

       

      My version of a poor man's upsert is to create an output dataset on the first run of a dataflow. After the first run, I add the output back into the dataflow as an input then do an inner join to update the existing records.

      I then add a UNION ALL and a left outer on the new records to add them in.  

    This discussion has been closed.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories