Deleting all records from a Database Table using Alteryx

[abdullah_noor23]

Hi Everyone,

Can anyone tell me how can I delete all the existing records from a database table using alteryx? Keep in mind I am not trying to write any new data, only need to remove the existing data. So, Can't use Delete & Append Options. Can anyone please help?

[KavyaSri9]

Hi @abdullah_noor23 ,Use any filter which gives you no data and write the data to Output tool.

[abdullah_noor23]

@KavyaSri9 ,

It does delete the data but all the dtatypes in the table column converts to double (8). So When I am trying to write on the table it gives me an error.

[Watermark]

You can force the data format/type/size by sticking a select statement after your final calculations, but before the 'output'. 

Taking it one step further, create an entirely new flow that does all the same output , and simply create a text input with zero data, followed by a select statement where (same as my first sentence) you dictate exactly what names, data types, sizes the columns are, and output that to the same tables with delete/append. 

[Watermark]

ps - if this works for you, please select answer for a solution. thx