Updating Alteryx Database

[jamesfbeard1]

Hello,

I have a workflow that is scheduled to run once a day, each day it produces 1 - 10 lines of data. I want to be able to output it so it constantly adds the new lines on to an Alteryx Database output for another workflow to read. How do you set it up so that you just add lines to the bottom of the output?

Many thanks,

James

[echuong1]

Unfortunately, there is no append data functionality when writing to a .yxdb file, unlike something like Excel.

What you can do is have your "running" file that you would like to append to as another input data tool. At the very end of the workflow just before the output data tool, you would union your new records with the data coming from the "running" input data file. You can specify the order of records in the union tool as well, so the new records are added to the bottom.

Let me know if that helps!

[jeff_reynolds · Accepted solution]

Hi there. Try the attached workflow, and data set. It should all work once unzipped, but if not, just point the input / output tools at the 'data.yxdb' file. 

Every-time this runs it will generate 10 new rows, increment a new ID value, add those 10 new rows to the original 10 and then write a new version of the data.yxdb file so that there is 20 rows, then 30, 40, 50, etc. 

Hopefully this helps you understand how it's done so that you can replicate something similar with your data. Good luck.