topic Re: Filter/Exclude Specific Values while loading Data. in QlikView

Filter/Exclude Specific Values while loading Data.

amithmurali — Tue, 14 Jul 2015 05:58:03 GMT

Hi guys.

I am having a field Product Code, Like the one given below.

Now while loading the data. i need to exclude all the codes starting with G.

It should like the following. with out any product codes starting with G.

Ralf-Narfeldt — Tue, 14 Jul 2015 06:05:19 GMT

You can add a where clause at the end of your load statement

Load ....

where Left(Productcode, 1) <> 'G';

maxgro — Tue, 14 Jul 2015 06:06:53 GMT

add a where to your load

where not left(Productcode,1)= 'G'

qlikmsg4u — Tue, 14 Jul 2015 06:11:33 GMT

Load

...

Where Left(Productcode,1)<>'G'

senpradip007 — Tue, 14 Jul 2015 06:14:30 GMT

Try to use this.

LOAD * Inline [

Productcode

A12344

CD1234

QC12345

G1234

GC1234245

RS23434

]

where not WildMatch(Productcode, 'G*');

MayilVahanan — Tue, 14 Jul 2015 06:15:59 GMT

You can try like this also

Where not WildMatch(ProductCode, 'G*');

// In Future, u need to remove any other ProductCode, you can add like this

Where not WildMatch(ProductCode, 'G*' , 'H*');