Skip to Content
0
Jun 09 at 03:40 PM

SAP Hana Studio Join Node many to many

47 Views Last edit Jun 09 at 03:49 PM 3 rev

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!