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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Union in ACS

alicep47308254
Level 4
Level 4

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

1 Accepted Solution
acharlier
Correct answer by
Level 1
Level 1

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

View solution in original post

7 Replies
florentlb
Level 10
Level 10

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

alicep47308254
Level 4
Level 4

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

acharlier
Level 1
Level 1

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

alicep47308254
Level 4
Level 4

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

acharlier
Level 1
Level 1

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

alicep47308254
Level 4
Level 4

Hello Aurélien,

yes. Two Queries defined on distinct resources.

Alice

acharlier
Correct answer by
Level 1
Level 1

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