Writing To An Alteryx Database

[carl_deli]

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

[PanPP]

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. 

[carl_deli]

Hi. 

I was referring to the actual Alteryx database. See the screenshot below. 

[DavidSkaife]

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

[PanPP]

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.