help on exists with multiple fields

[antonybi]

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!!

[tresesco · Accepted solution]

PFA

[antonybi]

Yes it worked.

Thank you!!

[antonybi]

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???

[tresesco]

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;