Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

how to delete rows that where not found before updating current ones?

Avatar

Level 4

Hi, currently my Update activity matches existing rows with rows comming from an external file, on @codtarjeta field. 

However, this will only update the rows where a match is found, leaving old rows unmodified and still in DB. 

Is there a setting I can use in the update activity, to tell it to: "delete rows in data base that are not comming any more from the external file"? 

 

 

ogonzalesdiaz_0-1699981305755.png

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @ogonzalesdiaz ,

You can modify your workflow as below,

ParthaSarathy_0-1699983622394.png

After data loading, using enrichment reconcile the temp data with targeting schema using reconciliation key.

ParthaSarathy_1-1699983737481.png

In Change dimension, select your targeting dimension, And next insert or Update the records.

ParthaSarathy_2-1699983782128.png

Parallelly, Query all the records from your schema, and exclude the records which is present in the file using exclusion activity and delete the records using Update data activity.

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hi @ogonzalesdiaz ,

You can modify your workflow as below,

ParthaSarathy_0-1699983622394.png

After data loading, using enrichment reconcile the temp data with targeting schema using reconciliation key.

ParthaSarathy_1-1699983737481.png

In Change dimension, select your targeting dimension, And next insert or Update the records.

ParthaSarathy_2-1699983782128.png

Parallelly, Query all the records from your schema, and exclude the records which is present in the file using exclusion activity and delete the records using Update data activity.