Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

MarcoARaymundo
Contributor III

Load data filtering using fields from another table

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?

Tags (1)
1 Solution

Accepted Solutions
jeffmartins
Contributor II

Re: Load data filtering using fields from another table

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:

2 Replies
jeffmartins
Contributor II

Re: Load data filtering using fields from another table

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
Contributor III

Re: Load data filtering using fields from another table

Thanks jeffmartins!

Community Browser