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

[god_prophet]

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?

[ParthaSarathy · Accepted solution]

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 .