Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Regarding fetching new data

Avatar

Employee

 I have uploaded a file for recipient schema, now I am uploading a new file for recipient schema with some of the existing values, I want to see only new inserted data by using activity in my workflow. I think I have to put join between existing and new data on customerID, But don't know how to do that.

 

Can anyone help me on this, an immediate response will be highly appreciated.

Below is my sample data

 

Mrityunjay_0-1655119735975.png

 

1 Accepted Solution

Avatar

Correct answer by
Level 4

Hello @Mrityunjay,

 

Use Enrichment activity to add a link to recipient :

 

Amine_Abedour_0-1655134073413.png

 

Amine_Abedour_1-1655134081675.png

 

Amine_Abedour_2-1655134091740.png

 

after that use this link to filter your work table so as to keep only the records with empty or null recipientId.

 

Br,

 

Amine

View solution in original post

0 Replies

Avatar

Correct answer by
Level 4

Hello @Mrityunjay,

 

Use Enrichment activity to add a link to recipient :

 

Amine_Abedour_0-1655134073413.png

 

Amine_Abedour_1-1655134081675.png

 

Amine_Abedour_2-1655134091740.png

 

after that use this link to filter your work table so as to keep only the records with empty or null recipientId.

 

Br,

 

Amine