Updating Alteryx Database

Question

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

jeff_reynolds · Accepted Answer

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.