topic Re: help on exists with multiple fields in QlikView

help on exists with multiple fields

antonybi — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Please help on this below scenario.

I've been trying to write where not exists in the script

but not getting desired output what exactly am looking for.

Output:

In the data model it should show

PFA for your reference!!

Any suggestions will be appreciated.

Thanks in advance!!

Re: help on exists with multiple fields

tresB — Fri, 10 Nov 2017 04:59:46 GMT

PFA

Re: help on exists with multiple fields

antonybi — Fri, 10 Nov 2017 05:03:55 GMT

Yes it worked.

Thank you!!

Re: help on exists with multiple fields

antonybi — Fri, 10 Nov 2017 05:38:13 GMT

Tresesco I need one more clarification in addition to that

master1:

load*,

edu&'|'&level as key

Inline

[

edu, level

grd, 3

pgrd, 4

mba, 5

btech, 6

be, 7

sslc, 1

intr, 2

mca, 8

];

NoConcatenate

master:

load* ,

edu&'|'&level as key

Inline

[

edu, level

grd, 3

pgrd, 4

mba, 5

btech, 6

be, 7

sslc, 1

intr, 2

mca, 9

]

Where not Exists(key,edu&'|'&level);

dROP Table master1;

Here my desired output shold be as below

How can we achieve this???

Re: help on exists with multiple fields

tresB — Fri, 10 Nov 2017 06:02:08 GMT

Try like:

master:

load *,

1 as Match1

Inline

[

edu, level

grd, 3

pgrd, 4

mba, 5

btech, 6

be, 7

sslc, 1

intr, 2

mca, 8

];

Join

load *

, 1 as Match2

Inline

[

edu, level

grd, 3

pgrd, 4

mba, 5

btech, 6

be, 7

sslc, 1

intr, 2

mca, 9

];

NoConcatenate

Final:

Load

*

Resident master where Match1<>Match2;

DROP table master;