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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Reconciliation options In Union Activity

NeelamBakre
Level 2
Level 2

Please help me understand the use of below option present in Union Activity by giving example. I read the document but did not get clear idea. 

Key Only

All Shared columns

Selection of Columns

 

1 Accepted Solution
Manoj_Kumar_
Correct answer by
Community Advisor
Community Advisor

Hello @NeelamBakre ,

Here is the description
Keys Only: Union activity will check common primary keys for the de-duplication/ reconciliation
All Shared Columns:
Union Activity will check all columns for the de-duplication.

Section of columns: Union Activity will check for the selected columns for the de-deup.

View solution in original post

3 Replies
Manoj_Kumar_
Correct answer by
Community Advisor
Community Advisor

Hello @NeelamBakre ,

Here is the description
Keys Only: Union activity will check common primary keys for the de-duplication/ reconciliation
All Shared Columns:
Union Activity will check all columns for the de-duplication.

Section of columns: Union Activity will check for the selected columns for the de-deup.

View solution in original post

NeelamBakre
Level 2
Level 2

Thank You @Manoj_Kumar_ ....and to use Keys Only option , we must have same columns present in all inbound transitions....right?