cancel
Showing results for 
Search instead for 
Did you mean: 

HANA Cross Join

Former Member

For one of our cases, we need a cross join between two nodes but HANA is allowing only left and right join, how do I do a cross join between two nodes in a Graphical Calculation View?

Accepted Solutions (1)

Accepted Solutions (1)

kapil_tilwani
Explorer

Hi Nikhil,

You can introduce a dummy column into a projection returning a constant (say 1) in both the nodes you intend to join. Join on the dummy columns. So, technically it is still an inner join but effectively a cross join.

Regards,

Kapil

Answers (0)