Update or Insert if new with YXDB possible?

[amien]

I'm now running an update or insert if new task in Alteryx. Works very good.  Can easiliy be set at "output options". The database is MSSQL.

I wanted to try to do the same with a YXDB database. But this option is here not available. Is this not possible here? Is this output option of "Update or Insert" really a database releated option?

Thanks in advanced

[MarqueeCrew · Accepted solution]

@amien,

There is an idea request for that functionality, but as for now the YXDB doesn't allow for an append.  What folks do to accomplish this is to place a BLOCK UNTIL DONE (your avatar) after the read from the yxdb and union that data together with data that they want to append.  The output from the union goes into the output tool and you overwrite the exising yxdb file.

Caution:  You might want to check for duplicate records before appending.

You might also want to consider using an output of SQLite and create a database table for output.  It doesn't perform as fast as a YXDB for reads/writes, but it does allow for the append function.

Thanks,

Mark