Filter/Exclude Specific Values while loading Data.

[amithmurali]

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

[Ralf-Narfeldt]

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

Load ....

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

[maxgro]

add a where to your load

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

[qlikmsg4u]

Load

...

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

[senpradip007]

Try to use this.

LOAD * Inline [

Productcode

A12344

CD1234

QC12345

G1234

GC1234245

RS23434

]

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

[MayilVahanan · Accepted solution]

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