Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
amithmurali
Contributor

Filter/Exclude Specific Values while loading Data.

Hi guys.

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

Productcode

A12344
CD1234
QC12345
G1234
GC1234245
RS23434

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.

Productcode
A12344
CD1234
QC12345
RS12234

ZE43321

1 Solution

Accepted Solutions

Re: Filter/Exclude Specific Values while loading Data.

Hi

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*');

5 Replies
Employee
Employee

Re: Filter/Exclude Specific Values while loading Data.

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

Load ....

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

MVP
MVP

Re: Filter/Exclude Specific Values while loading Data.

add a where to your load

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

qlikmsg4u
Valued Contributor

Re: Filter/Exclude Specific Values while loading Data.

Load

...

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

senpradip007
Valued Contributor III

Re: Filter/Exclude Specific Values while loading Data.

Try to use this.

LOAD * Inline [

Productcode

A12344

CD1234

QC12345

G1234

GC1234245

RS23434

]

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

Re: Filter/Exclude Specific Values while loading Data.

Hi

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*');

Community Browser