Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Is there a way to combine output options ?

prasannap
5 - Atom

Hi,

 

I want to combine "overwrite" and "create" for output to a table. So, if the table exists overwrite it and if it doesn't than create a new one. Many workflows fail for me due to this reason and I have to tweak it lot of times. If would be great to have this option.

 

Thank you 

3 REPLIES 3
ChrisTX
16 - Nebula
16 - Nebula

Which output format are you writing to?  The Excel output option for Overwrite File will do what you want, if the file exists it's overwritten, if it doesn't exist it is created.

 

Many other formats should overwrite a file if the file exists, as long as it's not locked.

 

Chris

prasannap
5 - Atom

Thank you Chris for your response. I am writing to a database table and not to a file.

ChrisTX
16 - Nebula
16 - Nebula

If a database table already exists, you'll need to DROP it before creating a new table with the same name.

 

See these posts about dropping a table:

Delete Records Using a Post SQL Statement Macro - Alteryx Community

delete tables and files - Alteryx Community

Solved: Re: Deleting Tables in the Database - Alteryx Community

 

Chris

Labels