Expand my Community achievements bar.

SOLVED

confused between Union and AND Join Activity in Adobe Campaign Classic

Avatar

Level 4

@Parvesh_Parmar ,@AkshayAnand 

,@isahore ,@AndreaBriceno,@ParthaSarathy

,@ParthaS ,@Craig_Thonis ,@Manoj_Kumar_ ,@Amine_Abedour ,@Marcel_Szimonisz,@DavidKangni 

,@Amit_Kumar,@ShashankNigam02,@Ganesh5067, @Jonathon_wodnicki

@Denis_Bozonnet 

Hi All,

 

I just read the documentation about AND join activity in Adobe Campaign but got confused between the purpose of AND Join activity and Union activity in Adobe Campaign

can someone please please help to explain exact difference AND Join activity and Union activity in Adobe Campaign

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @Shrutii ,

AND join and Union activity are completely different activities which serve different purposes.

Example if you are connecting 2 query activity's output transition to a union activity, the result of 2 queries will get grouped into a single target output.

Union Activity

 

Whereas when you are connecting 2 query activity's output transition to a AND join, the output result of AND join will be the result of the query activity which you had set as Primary set inside AND activity.

AND-Join

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi @Shrutii ,

AND join and Union activity are completely different activities which serve different purposes.

Example if you are connecting 2 query activity's output transition to a union activity, the result of 2 queries will get grouped into a single target output.

Union Activity

 

Whereas when you are connecting 2 query activity's output transition to a AND join, the output result of AND join will be the result of the query activity which you had set as Primary set inside AND activity.

AND-Join

Avatar

Level 3

Hi @Shrutii 

The SQL JOIN is used when we have to extract data from more than one table.

The SQL UNION is used when we have to display the results of two or more SELECT statements (from tables).

 

In the case of SQL JOINS, the records are combined into new columns.

In the case of SQL UNION, the records are combined into new rows.

InMo_2-1711438134153.png

 

Same way in Adobe campaign classic, you can check what your incoming temp tables are, and based use case, you can either use JOIN or UNION operation.

Hope this helps.

 

Regards,