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