community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Deletion of records from a table

It is great!!!

 

how did you remove the record one to one?

 

Thx.

Meteor

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 .

Labels