SAP Hana Studio Join Node many to many

[former_member733502]

Good afternoon,

I am working with SAP Hana Studio JOIN nodes.

I have two tables which I want to OUTER JOIN:

Table A

CASE_GUID USER
1 A
2 A   

Table B

LANGU
S
E  

The result should be the result of crossing each value in table A with each value in table B:

CASE_GUID USER LANGU
1 A E
2 A E
3 B E
1 A S
2 A S
3 B S   

I am trying to do this with the JOIN node with the Outer Join join type.

And I am getting this result:

CASE_GUID USER LANGU
1 A ?
2 A ?
3 B ?
? ? E
? ? S 

How should I achieve this result working with the HANA Studio nodes?

Thank you so much!

[former_member733502 · Accepted solution]

Good morning,

I solved the issue by not selecting the fields through which the join must be done. Just choosing the tables to join but not setting the crossing fields. It can also be done by creating a constant field in each table and outer joining the tables.

Thank you so much!

[Abhishek_Hazra · Accepted solution]

that's what is called cross join/referential join, where you don't specify the fields to join on. 🙂

[Abhishek_Hazra]

Hi,

You need to use referential join or cross join.

Best Regards,
Abhi