Load data filtering using fields from another table

[MarcoARaymundo]

Hi!

I have two tables: A and B. I want something like: Select * From A Where A.DTIN  > B.DTCK.

We can do this in Qlikview?

[jeffmartins · Accepted solution]

Hi thechacal,

First, you need to create a temporary table joining the tables A and B to get the fields DTIN and DTCK on the same table.

Then, you can create an other table to filter the values using the where clause DTIN > DTCK.

The code would be similar the following code:

tmp:

Load *;

Select * From A;

Left Join(tmp)

Load *;

Select * From B;

Table:

Noconcatenate

Load *

Resident tmp

Where DTIN > DTCK;

drop table tmp;

Hope it helps you

Regards:

[MarcoARaymundo]

Thanks jeffmartins!