topic Re: Help needed in Exists function in QlikView

Help needed in Exists function

Anonymous — Mon, 28 Nov 2016 19:16:05 GMT

Hi,

I have a table with two columns as below:

Table1:

DRG,

Wave

I have a second table with two columns FINALDRG, COST. The FINALDRG in the second table is same as the DRG in the first table.

So I have renamed the FINALDRG as DRG and the table looks like below:

Table2:

FINALDRG as DRG

COST

Now I have to load the table2 but with a condition. And the condition is, table2 should be loaded only with the DRGs which are loaded in table 1. How to do that? I tried using exists function but it is not working.

I have used the below script:

Table2:

Load * where exists(FINALDRG,DRG) but it is not working.

Thanks

Re: Help needed in Exists function

Vegar — Mon, 28 Nov 2016 19:19:40 GMT

You have switched the parameters. Try

Table2:

Load * where exists(DRG, FINALDRG)

Re: Help needed in Exists function

swuehl — Mon, 28 Nov 2016 19:20:35 GMT

Try

Load * where exists(DRG, FINALDRG);

The field to check comes first.

Re: Help needed in Exists function

Anonymous — Mon, 28 Nov 2016 19:28:32 GMT

Thanks Stefan, this worked

Re: Help needed in Exists function

Anonymous — Mon, 28 Nov 2016 19:28:51 GMT

Thanks Vegar. This worked