Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Intersection between query and load file activities

Avatar

Avatar
Give Back
Level 2
maurizio_coro
Level 2

Likes

15 likes

Total Posts

37 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Ignite 3
Ignite 1
Validate 10
Validate 1
View profile

Avatar
Give Back
Level 2
maurizio_coro
Level 2

Likes

15 likes

Total Posts

37 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Ignite 3
Ignite 1
Validate 10
Validate 1
View profile
maurizio_coro
Level 2

13-07-2018

Hello,

I'm facing an issue trying to configure the intersection activity.

Basically, I got a query extracting all the recipient in the DB and a data load file activity, with a csv with a list on ids. I need to intersect them to know how many recipient from the file actually exist in the recipient data model.

My issue rise whenever I try to configure the Intersection activity: it seems that any configuration works: I've tried to switch the Primary set (from query to data load) and I've set as reconciliation key a selection of column, setting first the recipient ID and then the ID field from the file.

Nothing works. Any idea?

thanks

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Vapsy
Employee

16-07-2018

HI maurizioc92956636 ,

There is a better way to do this

Your current design is resource exhaustive as it will unnecessarily pull all recipients from database and then tries to reconcile the data from file.

Using this new design you need to only work on data in your file.

So for explanation purposes, I have used a file with three columns and I'll be using email as the column for reconciliation.1528773_pastedImage_3.png

Connect the file loading activity to Enrichment activity.

1528774_pastedImage_4.png

On the enrichment activity, go to Reconciliation tab and enable the option "identify the document from working data".

Select the targeting dimension as "Recipient" and then define the reconciliation keys as well. In my keys it was the email column

1528775_pastedImage_5.png

Hit Ok and Save the workflow.

This will output only those records from file which had a matching recipient inside database.

Regards,
Vipul

Answers (1)

Answers (1)

Avatar

Avatar
Give Back
Level 2
maurizio_coro
Level 2

Likes

15 likes

Total Posts

37 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Ignite 3
Ignite 1
Validate 10
Validate 1
View profile

Avatar
Give Back
Level 2
maurizio_coro
Level 2

Likes

15 likes

Total Posts

37 posts

Correct Reply

0 solutions
Top badges earned
Give Back
Ignite 3
Ignite 1
Validate 10
Validate 1
View profile
maurizio_coro
Level 2

16-07-2018

Thanks a lot! Worked perfectly.