Skip to main content
New Participant
September 27, 2017

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

  • September 27, 2017
  • 2 replies
  • 4876 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
New Participant
October 2, 2017

yes exclusion is also a solution

Marcel

Marcel_Szimonisz
New Participant
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

New Participant
October 2, 2017

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