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

Avatar

Avatar
Validate 1
Level 2
srikanthr646926
Level 2

Likes

4 likes

Total Posts

23 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
srikanthr646926
Level 2

Likes

4 likes

Total Posts

23 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile
srikanthr646926
Level 2

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
Springboard
MVP
MarcelSzimonisz
MVP

Likes

102 likes

Total Posts

227 posts

Correct reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile

Avatar
Springboard
MVP
MarcelSzimonisz
MVP

Likes

102 likes

Total Posts

227 posts

Correct reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile
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

Avatar

Avatar
Validate 1
Level 2
srikanthr646926
Level 2

Likes

4 likes

Total Posts

23 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
srikanthr646926
Level 2

Likes

4 likes

Total Posts

23 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile
srikanthr646926
Level 2

02-10-2017

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

Avatar

Avatar
Springboard
MVP
MarcelSzimonisz
MVP

Likes

102 likes

Total Posts

227 posts

Correct reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile

Avatar
Springboard
MVP
MarcelSzimonisz
MVP

Likes

102 likes

Total Posts

227 posts

Correct reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile
MarcelSzimonisz
MVP

02-10-2017

yes exclusion is also a solution

Marcel