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

Full Outer Join in ACC

pradyumns539618
Level 3
Level 3

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 

1 Accepted Solution
wodnicki
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

5 Replies
Adhiyan
Employee
Employee

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

 

Adhiyan
Employee
Employee
Thanks Pradyumn for letting us know. Could you please mark the answer as correct if it solved your query
pradyumns539618
Level 3
Level 3
Hi Adhiyan , Sorry for late response ! I can't see any option here to mark as answered .
wodnicki
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post