how to delete selective records in target table using alteryx?

[bhardwajankita07]

Hi Team,

I want to perform incremental load in redshift using alteryx, which i am not able to achive from  "Update;Insert if new" option in output_data tool.

So while inserting the data into the target table, I want to delete the already existing records and append the new and updated records to the target.

So can you just tell me how to delete selective records from the target table, because when I use delete option in Output tool it delete the complete table.

Regards,

Ankita Bhardwaj

[bhardwajankita07]

Thanks a lot, that was really quick and valuable response.