Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
RÉSOLU

Writing output to access tables automatically

Serkan_Varol
Météoroïde

Hello,

 

I have a workflow that I run 10-12 times a day. I want this workflow to write in this into an existing database - .accdb (on my desktop) inside different table names. I do want to change the table name each time I run the workflow (just want to hit the "run" button).

 

I have pretty much everything automated except that part. Any help is appreciated:)

1 RÉPONSE 1
alexnajm
16 - Nebula
16 - Nebula

You should be able to use a Formula tool just before the end to create this new table name, then "Take File/Table Name from Field" from the bottom of your Output Data tool to write to that newly created table name! I haven't done it with Access, but it works well with other output methods.

Étiquettes