Highlighted

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

Avatar

Avatar

srikanthr646926

Avatar

srikanthr646926

srikanthr646926

27-09-2017

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.

Replies

Avatar

Avatar

MarcelSzimonisz

MVP

Avatar

MarcelSzimonisz

MVP

MarcelSzimonisz
MVP

02-10-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.

1316120_pastedImage_2.png

Marcel

Highlighted

Avatar

Avatar

srikanthr646926

Avatar

srikanthr646926

srikanthr646926

02-10-2017

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

Highlighted

Avatar

Avatar

MarcelSzimonisz

MVP

Avatar

MarcelSzimonisz

MVP

MarcelSzimonisz
MVP

02-10-2017

yes exclusion is also a solution

Marcel