Expand my Community achievements bar.

Accelerate your Campaign learning with the Adobe Campaign Mentorship Program 2023!
SOLVED

Union Acitivity

Avatar

Level 5

What is the purpose of reconciling on selected columns in Union Activity? Thanks

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @Sanjana12 ,

By default in union (keys only reconciliation) will union the target data based on primary key.

If we want to do union based on a particular attribute/field, 'A selection of column' option will be helpful.

The below example might help you getting answer,

There are 2 files,

File1 - address.csv which have customer id and email address

customer_idemail
123test1@test.com
456abc@gmail.com
789123@yahoo.com

 

File2 - offer.csv which have customer id and offer

customer_idoffer
789offer3
             001offer4
123offer1
456offer2

 

ParthaSarathy_0-1686052495018.png

 

Importing this 2 files, and by selecting 'keys only' in union, offers and email are assigned to customer id based on primary key (here, line number). When you compare with above mentioned file data, this mapping output of union is wrong.

ParthaSarathy_1-1686052567067.png

 

So the correct way to union here is, by selecting 'a selection of column' in reconciliation and selecting 'customer_id' column, we can see the correct mapping of email id - offer and customerId as per files.

ParthaSarathy_2-1686052771148.png

 

 

View solution in original post

3 Replies

Avatar

Level 6

Hi @Sanjana12 

 

You can use reconciliation when you need to create a temporary joining condition for two transitions (similar to reconciling in enrichment activity).
Eg, if the transition are not in same dimension then to create a linkage you can use this option to define a field and create a link/reconciliation. 

You can refer here for more details.

 

Regards

A

Avatar

Correct answer by
Community Advisor

Hi @Sanjana12 ,

By default in union (keys only reconciliation) will union the target data based on primary key.

If we want to do union based on a particular attribute/field, 'A selection of column' option will be helpful.

The below example might help you getting answer,

There are 2 files,

File1 - address.csv which have customer id and email address

customer_idemail
123test1@test.com
456abc@gmail.com
789123@yahoo.com

 

File2 - offer.csv which have customer id and offer

customer_idoffer
789offer3
             001offer4
123offer1
456offer2

 

ParthaSarathy_0-1686052495018.png

 

Importing this 2 files, and by selecting 'keys only' in union, offers and email are assigned to customer id based on primary key (here, line number). When you compare with above mentioned file data, this mapping output of union is wrong.

ParthaSarathy_1-1686052567067.png

 

So the correct way to union here is, by selecting 'a selection of column' in reconciliation and selecting 'customer_id' column, we can see the correct mapping of email id - offer and customerId as per files.

ParthaSarathy_2-1686052771148.png