Workflow design suggestion | Community
Skip to main content
Level 3
January 9, 2024
Solved

Workflow design suggestion

  • January 9, 2024
  • 1 reply
  • 520 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ParthaSarathy

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.

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
January 9, 2024

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.

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