topic Re: Removing matching values in QlikView

Removing matching values

Wed, 13 Aug 2014 06:12:44 GMT

Hi all,

Till now I have worked with joins and worked out well.

Now i have an opposite use of it.

I have two Excel Tables:

Lets say

One:

the field Alphabets and having values from a to z

Second:

The Field Vowels having values a,e,i,o,u

Now I want to remove the vowels from my table One without hardcoding.

Can I implement it in the load script in a way?

Thanks in advance

Re: Removing matching values

kaushiknsolanki — Wed, 13 Aug 2014 06:17:55 GMT

Hi,

First Load the one which you want to remove, so in your case Vowels.

Then load second table from where you want to remove, in your case a to z.

Then use the exists function.

Sample script will be.

Load Vowels from xyz.

Load Alphabets from pqr where not exists (Vowels,Alphabets);

Regards,

Kaushik Solanki

Re: Removing matching values

ashfaq_haseeb — Wed, 13 Aug 2014 06:19:25 GMT

Try like this

Vowels:

Load * Inline

[

Field1

];

Alphabet:

load * Inline

[

Field2

]

Where not Exists(Field1,Field2);

Regards

ASHFAQ

Re: Removing matching values

er_mohit — Wed, 13 Aug 2014 06:24:52 GMT

Yeah you can use where exist function for your case

first load the table which have vowels then load another tables which have data upto a to z. then use where not exist function.

try below script

Table1:

LOAD * Inline [

]

;

Table2:

LOAD * Inline [

]Where not Exists(F2,F1);

Re: Removing matching values

Wed, 13 Aug 2014 06:29:13 GMT

Thank you all so much... Problem solved