Workflow design suggestion

[Rut7]

Hi All,

I have a file containing X records. I want to load these records in the Y table. Before loading records in the X file in the Y table. I want to understand how many records from the X file are already present in the Y table and how many are not present. The primary key is the recipient ID. What is the best possible design for this workflow and which activities will be useful to design this workflow?

Thank you,

Rutuja Kelkar

[ParthaSarathy · Accepted solution]

Hi @Rut7 ,

You can refer this import workflow documentation.

'primary key not equals to 0' subset count is the number of records already present in table Y. And rest subset's counts are new records.