Is it Possible to do a right Join In Enrichment Activity? | Community
Skip to main content
Level 2
Sep 27, 2017 2:13 PM UTC

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

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.

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

3 replies

Marcel_Szimonisz
New Participant
Oct 2, 2017 1:07 PM UTC

yes exclusion is also a solution

Marcel

Translate
Marcel_Szimonisz
New Participant
Oct 2, 2017 12:28 PM UTC

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.

Marcel

Translate
Level 2
Oct 2, 2017 12:53 PM UTC

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

Translate