Is it Possible to do a right Join In Enrichment Activity? | Community
Skip to main content
Level 2
September 27, 2017

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

  • September 27, 2017
  • 2 replies
  • 4880 views

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.

2 replies

Marcel_Szimonisz
Community Advisor
Community Advisor
October 2, 2017

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

Level 2
October 2, 2017

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

Marcel_Szimonisz
Community Advisor
Community Advisor
October 2, 2017

yes exclusion is also a solution

Marcel