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
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
Thank you Chris for your response. I am writing to a database table and not to a file.
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