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

Union in ACS

Avatar

Avatar
Validate 10
Level 3
alicep47308254
Level 3

Likes

18 likes

Total Posts

43 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
alicep47308254
Level 3

Likes

18 likes

Total Posts

43 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
alicep47308254
Level 3

12-09-2017

Hello,

I am a bit confused about the Union in the Targeting Activies.

I am tring to put together to different query using the Union but If is possible I want to see an example.

Thank you

Alice

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 1
Level 1
acharlier
Level 1

Likes

2 likes

Total Posts

3 posts

Correct Reply

1 solution
Top badges earned
Boost 1
Affirm 1
View profile

Avatar
Boost 1
Level 1
acharlier
Level 1

Likes

2 likes

Total Posts

3 posts

Correct Reply

1 solution
Top badges earned
Boost 1
Affirm 1
View profile
acharlier
Level 1

20-09-2017

OK

Do you have one or several common data colums on your resources ?

If yes, define it as an additionnal data in both queries with same alias (crucial point ) and use that field as a reconcialiation key

Aurélien

Answers (6)

Answers (6)

Avatar

Avatar
Validate 10
Level 3
alicep47308254
Level 3

Likes

18 likes

Total Posts

43 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
alicep47308254
Level 3

Likes

18 likes

Total Posts

43 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
alicep47308254
Level 3

20-09-2017

Hello Aurélien,

yes. Two Queries defined on distinct resources.

Alice

Avatar

Avatar
Boost 1
Level 1
acharlier
Level 1

Likes

2 likes

Total Posts

3 posts

Correct Reply

1 solution
Top badges earned
Boost 1
Affirm 1
View profile

Avatar
Boost 1
Level 1
acharlier
Level 1

Likes

2 likes

Total Posts

3 posts

Correct Reply

1 solution
Top badges earned
Boost 1
Affirm 1
View profile
acharlier
Level 1

20-09-2017

Hello Alice,

"two queries with different profile"  => you mean 2 queries defined on distinct resource (see image below)

Or 2 queries with same resource ?

Capture_Properties_Query_ACS.JPG

Aurélien

Avatar

Avatar
Validate 10
Level 3
alicep47308254
Level 3

Likes

18 likes

Total Posts

43 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
alicep47308254
Level 3

Likes

18 likes

Total Posts

43 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
alicep47308254
Level 3

20-09-2017

Hi Aurélien,

in my example I am going to put together two queries with different profile.

If it is possible, I would like to see how to do in the Union Activities.

Thank you

Alice

Avatar

Avatar
Boost 1
Level 1
acharlier
Level 1

Likes

2 likes

Total Posts

3 posts

Correct Reply

1 solution
Top badges earned
Boost 1
Affirm 1
View profile

Avatar
Boost 1
Level 1
acharlier
Level 1

Likes

2 likes

Total Posts

3 posts

Correct Reply

1 solution
Top badges earned
Boost 1
Affirm 1
View profile
acharlier
Level 1

20-09-2017

Hi Alice,

As mentioned by Florent, two queries going into union activity must come from same ressource.

But, it's possible to join 2 activities from different ressource, supposing you have a common field

Define an additional data in both ressources with same alias

Use that field with "selection of columns" reconciliation type

Aurélien

Avatar

Avatar
Validate 10
Level 3
alicep47308254
Level 3

Likes

18 likes

Total Posts

43 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
alicep47308254
Level 3

Likes

18 likes

Total Posts

43 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
alicep47308254
Level 3

19-09-2017

Hi Florent,

I read the guide but in this targeting action there aren't screenshots about all the details inside this activity.

Do you have any example of different using for example "keys only" or "a selection of coloumns" in the Reconciliation type?

Thank you

Alice

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

15-09-2017

Hi Alice,

The Union activity is described in the docs here: Union

Remember that the two queries that go to the union activity must target the same resource (2 queries on profiles, etc.).

Can you describe what you want to do with more details ? Don't hesitate to share screenshots as well.

Let me know,

Florent