Discussion board where members can get started with QlikView.
This script doesn't work (Field not found: <level>):
LOAD * INLINE [
low, high, levelName
1, 3, warning
4, 7, error
8, 9, fatal
LOAD levelName resident Table1
where (level >= low and level <= high);
What I wanted is to produce the table
Is this only possible by first producing a (far too huge) table doing a cross join on Table1 and Table2 followed by filtering?
LOAD * resident Table1; // Result-table is too big
load num, levelName resident Table2
drop table Table1;
drop table Table2;
Go to Solution.
You can use intervalmatch here. I have made a sample script for you. Modify it according to your need.
Inner Join(Table3) LOAD
0 as junk
DROP Table Table1;
Left Join(Table3) LOAD
0 as junk1
DROP Table Table2;
DROP Fields low,high,junk,junk1,level;
I would prefer a more generic method where the join statement supported a 'where' part where fields from both tables could be tested. But I guess that is not possible.
For now, your solution is sufficient.Thanks