Avatar

Level 2

Hi @CedricRey 

 

Thanks for the response.

 

Here is what I have to achieve. I have to delete a list of Campaigns, and also deliveries which are composed in that campaigns.

 

sirikambampati_2-1653068440968.png

 

I am fetching all the campaigns in a query activity. First I have to delete the deliveries, I am using a Update DB activity and linking the operation Id from the result set of query activity to the operation id in deliveries schema. Which should delete all the deliveries with that particular operation id. 

After that I am using another Update DB activity and targeting Campaigns schema and linking the Id's.

 

But its not working, what is the problem with this.

 

I have to delete all the deliveries associated to a campaign first and then delete the campaigns too.

So which activities I should be using?

 

I have also tried using change dimension, but it didn't work.

 

Thanks,

~SK