Union in ACS

Avatar

Avatar

alicep47308254

Avatar

alicep47308254

alicep47308254

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

acharlier

Avatar

acharlier

acharlier

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

alicep47308254

Avatar

alicep47308254

alicep47308254

20-09-2017

Hello Aurélien,

yes. Two Queries defined on distinct resources.

Alice

Avatar

Avatar

acharlier

Avatar

acharlier

acharlier

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

alicep47308254

Avatar

alicep47308254

alicep47308254

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

acharlier

Avatar

acharlier

acharlier

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

alicep47308254

Avatar

alicep47308254

alicep47308254

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

florentlb

Total Posts

1.1K

Likes

233

Correct Answer

239

Avatar

florentlb

Total Posts

1.1K

Likes

233

Correct Answer

239
florentlb

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