Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need Help on Conditional Joins

Need Help Please

I am trying to join 2 tables in Calculation View of SAP HANA

1) Salary Table

Salary_Slab, Salary_Start, Salary_End
A,                  10000,            20000
B,                  20000,            30000
C,                  30000,            40000
D,                  40000,            50000

2) Employee Table

Employee_Number, Salary
01,                       15000
02,                       18000
03,                       32000
04,                       45000


The Output I need is the Employee Details with the corresponding Slab


Employee_Number, Salary, Slab

01,                       15000,      A
02,                       18000,      A
03,                       32000,      C
04,                       45000,      D


Can you please suggest how to Achieve this without writing Scripts.

Former Member
Not what you were looking for? View more on this topic or Ask a question