Discussion board where members can get started with Qlik Sense.
I got some questions on comparing value in different table.
I would like to ask how to check which Key in table A belong to Class Y in Table B
Mapping load * inline
load ApplyMap('TableA',Lower Range,'N') as Class,* inline
Loser Range,Upper Range
Thx for reply!
The column Class does not exist in Table A.
Mapping load 'Y' as Class,* inline
Use an interval match in the pattern:
Let epsilon = 1e-9;
FROM ...table A...
Left Join (A)
LOAD [Lower Range],
[UpperRange] - epsilon as [Upper Range]
FROM ...table B...
[UpperRange] - epsilon as [Upper Range],
Replace the ellipses with the correct FROM clauses for your requirements. The value epsilon is a small amount to make sure that a value like 10 does not get assigned two class values.
You can drop the field [Lower Range] and [Upper Range] if you have no further need for them.