Full Outer Join in ACC

pradyumns539618

24-02-2020

Hi ,

 

Does Adobe Campaign support Full Outer Join ?

My requirement is : We have two table A(Customer) and B(Restaurant) ,Table A has column (X coordinates  and Y coordinates ) geographic location of Customer and Table B has column ((X coordinates  and Y coordinates ) geographic location of Restaurant .

I would like create 1 recordset of data from both table having the all four columns . I tried with Union but it failed , as there is no link between both tables .So we can't do it using reconciliation . Please let us know if is there any workaround for it .

 

Please let me know if you need more detail on it .

 

Thanks!

 

@wodnicki @Jean-Serge_Biro @Venu_Reddy  @kapilKochar 

Accepted Solutions (1)

Accepted Solutions (1)

wodnicki

MVP

25-02-2020

Hi,

 

Cartesian join? Every customer maps to every restaurant?

This can be done with either schema definition, join key is 1=1, or enrichment with simple join (any cardinality is fine), 1=1.

 

Thanks,

-Jon

Answers (1)

Answers (1)

Adhiyan

Employee

25-02-2020

Hi Pradyumn,

 

Did you try enrichment in this scenario. It should be possible to add the table B as a link and extract the columns.

You should query the records of table A , then add a enrichment activity and add the data as a link for table B.

 

In the enrichment , select add data and then select A link :

 

Adhiyan_0-1582633226665.png

 

In the next step , choose the table B and it would extract the columns from that table.

 

Regards,
Adhiyan