The Community SSO is undergoing updates. Users signing in may experience issues. We appreciate your patience as we complete these updates.

Alteryx Designer Desktop Discussions

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

Writing output to access tables automatically

Serkan_Varol
6 - Meteoroid

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 REPLY 1
alexnajm
17 - Castor
17 - Castor

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.

Labels