Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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
18 - Pollux
18 - Pollux

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
Top Solution Authors