Delete Alteryx Database (YXDB)

Hello,

I'd like to delete or refresh an Alteryx database (yxdb extension).

I have a workflow that requires a fresh 'empty' database to push data into. I'd like to keep the same name, but insert a method of simply deleting all the rows before the fresh insertion of data.

Thank you,

Frank.

Datasets

Accepted answers

fmvizcaino

Hi @Frank_Rock ,

If the only thing you need to do is to read a file with 0 rows of data, you only need to configure your input data tool to read 0 rows as image below.

Best,

Fernando Vizcaino

All comments

fmvizcaino

Hi @Frank_Rock ,

I'm attaching an example using block until done tool where you save a database with no data and right after save all the data.

I'm not sure if it is that what you need, but you can adapt to whatever you need.

Best,

Fernando Vizcaino

2020-02-17 Delete Alteryx Database (YXDB).yxmd

Frank_Rock

The path to your test.yxdb is to your desktop, so I'm getting an exclamation point error. I can read through it, however, but I'm not sure if this will work.

This procedure will have to be done over and over again. I'm not sure if this works as I need to actually clear the database of information. Saving with no information won't clear information already inside the yxdb database, will it?

It's a weekly process. Data flows through the workflow, and then ultimately resides in a database (yxdb).

The next week, that yxdb database needs to be emptied and ready for new data.

fmvizcaino

Hi @Frank_Rock ,

If the only thing you need to do is to read a file with 0 rows of data, you only need to configure your input data tool to read 0 rows as image below.

Best,

Fernando Vizcaino

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235