Full Outer Join in ACC

Question

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!

@jonathon_wodnicki @jean-serge_biro @venu_reddy @kapilkochar

Jonathon_wodnicki · Accepted Answer

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

Adhiyan · Answer

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 :

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

Regards,
Adhiyan

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded