topic Re: where not exists in QlikView

where not exists

Wed, 02 Jul 2014 12:48:43 GMT

Hello everybody,

i have a question please :

I got two tables with a common field "codeexpldef" . On the left table is called ADR_EXPL and on the right side adr_codif.

I'd like to have on a table the common numbers "Codeexpldef" of ADR_EXPL and adr_codif and all the informations of ADR_EXPL .

Should i do like that:

qualify*;

unqualify [Codeexpldef];

final:

load* resident ADR_EXPL2;

final:

Concatenate

load * resident adr_codif2 where exists (Codeexpldef);

i want all on a table but when i launched that, i have one table but with fields final... and final-1..

and if i did unqualify*; unstead qualify*; that not work no table created.

Thanks a lot and sorry for my bad english guys!

Wed, 02 Jul 2014 13:00:44 GMT

Hoping you want only one final table,

Load * from

ADR_EXPL ;

Left join

Load * from

adr_codif ;

Regards,

Prabhu

PradeepReddy — Wed, 02 Jul 2014 13:12:23 GMT

Method-1:

ADR_EXPL:

Load * From ADR_EXPL;

Inner Join

adr_codif:

Load * From adr_codif;

Method-2:

ADR_EXPL:

Load * From ADR_EXPL;

adr_codif:

Load * From adr_codif

where exists(ADR_EXPL.codeexpldef,adr_codif.codeexpldef);

Regards,

Pradeep