Is there a way to combine output options ?

Question

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

ChrisTX · Answer

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

prasannap · Answer

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

ChrisTX · Answer

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