Apply conditions to tables created from QVDs

iJuanico — Fri, 24 Jun 2022 20:05:28 GMT

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

FROM [FILE_A.qvd](qvd);

INNER JOIN(BIG_TABLE)

LOAD

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?

Re: Apply conditions to tables created from QVDs

rubenmarin — Sat, 25 Jun 2022 07:13:46 GMT

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.

topic Re: Apply conditions to tables created from QVDs in App Development

Apply conditions to tables created from QVDs

Re: Apply conditions to tables created from QVDs