How to load a file and delete all the records not presented in the file but present in the schema? | Community
Skip to main content
G
god_prophet
Level 6
May 20, 2025
Solved

How to load a file and delete all the records not presented in the file but present in the schema?

  • May 20, 2025
  • 1 reply
  • 395 views

So, I need to:

1.- Load a file.
2.- Insert the new records and update the ones that are present in the schema byut maybe have one or more fields updated.
3.- Delete all the records not presente in the file, but already inserted in the schema (those were inserted in previous executions of the workflow).

Should it be done in the same workflow?

Best answer by ParthaSarathy

Hi @god_prophet ,

You can use the below logic to solve it,

Fetch all records from Query and exclude the records from data loading activity. In exclusion activity set primary set as 'Query' . And now Delete the result records with Update data activity. (Test the above in lower environment)

 

This is just an logic idea to solve the case, you can modify the workflow as per your requirement .

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
May 21, 2025

Hi @god_prophet ,

You can use the below logic to solve it,

Fetch all records from Query and exclude the records from data loading activity. In exclusion activity set primary set as 'Query' . And now Delete the result records with Update data activity. (Test the above in lower environment)

 

This is just an logic idea to solve the case, you can modify the workflow as per your requirement .

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    Terms & ConditionsAccessibility statement

    Loading footer...