Hello Everyone,
Is there a way to write to an Alteryx database with the constraint that is APPENDING, not replacing? As is now, my workflow just replaces the old data once a new iteration is fed through. Is there a setting for the database to be appending as opposed to this?
Thanks
Hi @carl_deli
You can see the various outputs in the Input tool configuration window.
There is an option to Append existing.
Hope this helps.
Hi.
I was referring to the actual Alteryx database. See the screenshot below.
Hi @carl_deli
You're unable to append to a .yxdb, but what you can do is the below as a workaround:
The aim of the Block Until Done Tool is to stop anything writing to the .yxdb before all data has been passed through
You can't append to a yxdb file.
What you can do is output and append your data to an excel file.
Then bring that excel file back into Designer and output the data to your .yxdb.
Hope this helps.