Need Help on Conditional Joins

[former_member624795]

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.

[lbreddemann]

You may want to look into the temporal-join available in analytic views.

That should do exactly, what you want.

- Lars