Hello community, I have a question about how to apply a condition, I am currently building an application that is based on a table (BIG_TABLE) formed from QVDs:
[BIG_TABLE];
LOAD
A1
A2
A3
FROM [FILE_A.qvd](qvd);
INNER JOIN(BIG_TABLE)
LOAD
B1
B2
B3
FROM [FILE_B.qvd](qvd);
I need to apply to the table formed BIG_TABLE, the following condition: WHERE A2 <= B3, note that both fields come from different tables, how can I do this in Qlik Sense?
Hi, these tables doens't have anuy common field, it's that the way they are loading in the real data?
If there is a common field you can use a mapping table and applymap to filter the data joined from FILE_B.
If you really want a combination of all rows from one qvd to all of the other that meet the condition you can join them all and then aply the condition using a resident table:
END_BIG_TABLE:
NoConcatenate LOAD * Resident BIG_TABLE WHERE A2 <= B3;
DROP Table BIG_TABLE ;
But maybe you need a lot of RAM and Time to do this load.
If A2 doesn'thave too many different values you can do a bucle to load using an iteration for each value of A2 so each iteration only load the needed value, saving RAM needed.
