Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Deletion of records from a table

It is great!!!


how did you remove the record one to one?




Hi - I created a temporary table in my putput tool which will track all the deleted records and then added a post sql delete to remove those from that table. To identify the deleted records i used outer join and is_null condition to find the records that are removed. which worked good.


However now im facing a new challenge and added a new post for that. which is addressing forign keys . Deletion now happens if there are no dependencies on the records . But if the records primary key is referenced in other tables update/delete is failing with foreign key violation. So i need to take care of those tables first .


I know the tables, but not sure how to add these dependencies in my current workflow .