Saving data in a alteryx database

[AlexGavri]

Hello everyone,

I am working on a alteryx app that is taking as an input a few different things, like name, e-mail etc.

The problem that I have is every time I run the app with a new entry instead of adding the entry to my .yxdb (database file) it is overwritting my last entry.

Can solve with a excel file but it needs to be .yxdb.

Am I not using the right output tool?

Any ideas???

Thanks

[binu_acs · Accepted solution]

@AlexGavri one option is to use the input tool and read the data from the .yxdb database then append the result to this file before writing, this way you can keep the prior values in the yxdb file. Use the Block Until done tool to read and write from the same file

[AlexGavri]

Hi,

Thanks for your help. That worked.

One small issue: Every time I run the app,  it will add the appended info on the same row in the database. Is there a way to start a line every time I run.

Sorry but I'm fairly new to alteryx.

Thanks

[AlexGavri]

Fixed. Using the Union tool instead o Append will let me keep the columns the way I want them.

Thanks