MySQL query structure for merge update feature

user02464

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! 

laura_igl

Hi,

Is anyone able to help out with this request?

Thanks,

VictorReyes

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.