Union in ACS

[alicep47308254]

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

[florentlb]

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]

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]

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]

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]

Hello Alice,

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

Or 2 queries with same resource ?

Aurélien

[alicep47308254]

Hello Aurélien,

yes. Two Queries defined on distinct resources.

Alice

[acharlier · Accepted solution]

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