Is there a way to combine output options ?

[prasannap]

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]

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]

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

[ChrisTX]

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