Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to write a code in exists function between two tables

i have writing to a code in exists () between two tables...but i have face some errors.i have attached the qvw file please check it.

i am looking for the answer

if where not exists(F1)

i want to display

F1 F2

1     200

2     300

3     400

4     500

5     600

3 Replies
sushil353
Honored Contributor II

Re: How to write a code in exists function between two tables

Hi,

Try this code

Tab1:
LOAD F1,
F2
FROM

(
txt, codepage is 1252, embedded labels, delimiter is ',', msq)
;


Tab2:
LOAD F1,
F2
FROM

(
txt, codepage is 1252, embedded labels, delimiter is ',', msq)
where not Exists(F1);

HTH

Sushil

bhagirath
Contributor III

Re: How to write a code in exists function between two tables

use attached qvw

Not applicable

Re: How to write a code in exists function between two tables

Tab1:

LOAD F1,

     F2

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Tab2:

LOAD F1,

     F2

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Tab3:

load * resident Tab1;

load * resident Tab2 where not exists(F1,F1);

It state first parameter F1 represent Tab1 field will look into second parameter F1 represent Tab2 field if it will not exist in Tab2 then those field-value will be taken into F1 rest exclude.

& in your script both table field are same it will auto-concatenate to avoid that rename Tab3 field values...