Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Saving data in a alteryx database

AlexGavri
7 - Meteor

2024-01-20_10h12_01.pngHello 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

3 REPLIES 3
binuacs
21 - Polaris

@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
7 - Meteor

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
7 - Meteor

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

Thanks

Labels
Top Solution Authors