Deleting all records from a Database Table using Alteryx

Question

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?

Watermark · Answer

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

Watermark · Answer

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.

abdullah_noor23 · Answer

@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.