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
BedrockMission!

Learn more

View all

Sign in to view all badges

Is it Possible to do a right Join In Enrichment Activity?

srikanthr646926
Level 2
Level 2

My source is a file and I want to check the previous days loads have any additional IDs than new File, if yes I need to delete and update the data for any changes. There are multiple ways to do that, We can do using exclusion activity for the deleted but I am trying to see if we can do using Enrichment activity reconciliation tab to find ids no longer valid. I need something like right join.

3 Replies
MarcelSzimonisz
Community Advisor
Community Advisor

Hello,

Only I can think of is to query anything from second table in right join and then change dimension to first table in the right join select.

1316120_pastedImage_2.png

Marcel

srikanthr646926
Level 2
Level 2

Thanks Marcel , I did it with Exclusion Activity for my requirement

MarcelSzimonisz
Community Advisor
Community Advisor

yes exclusion is also a solution

Marcel