How to remove values in column in script?

[#1]

Hi i have one column

Country

a

b

c

d

e

now i want remove a,b,c values in country coumn

in qlikview script

please help on that

[#2]

first load all data which is not required in that particular column. This table should reflect ass different entity in data model.

then you can restrict record using join or using where clause

[#3]

Hi ,

Try like this :

Table1:

LOAD * INLINE [

   Country

    a

    b

    c

    d

];

NoConcatenate

load * Resident Table1 where not wildmatch(Country,'a','b','c');

drop table Table1;

Thanks !!

[sujeetsingh]

Load*

from table where wildmatch(Country,'a','b','c')<>1

[qlikmsg4u]

YOU CAN USE where condition while loading the data.

Where not match(country, 'a','b','c')

[MayilVahanan]

Hi

Try like this

Load * from table where not match(Country,'a','b','c');