Expand my Community achievements bar.

SOLVED

Union in ACS

Avatar

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

Avatar

Correct answer by
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

Avatar

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

Avatar

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

Avatar

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

Avatar

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

Avatar

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

Avatar

Level 4

Hello Aurélien,

yes. Two Queries defined on distinct resources.

Alice

Avatar

Correct answer by
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