Beginners in Qlikview I am back with another scenario i.e. Interval Match.
I have two tables Employees, Job grades. The task here is to find out the Grade level of the employees. The same can be achieved in SQL as below using joins
Where employees.SALARY >= job_grades.LOWEST_SAL and employees.SALARY <= job_grades.HIGHEST_SAL
Coming to Qlik view we do a interval match for this, the following code is what I used.
(ooxml, embedded labels, table is employees);
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
Note: One noticeable point here is, I couldn't get rid of the synthetic keys. Is there a way that can be done.
Hope this helps.