topic Re: How to remove values in column in script? in QlikView

How to remove values in column in script?

Fri, 05 Sep 2014 09:54:12 GMT

Hi i have one column

Country

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

in qlikview script

please help on that

Fri, 05 Sep 2014 09:57:31 GMT

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

Fri, 05 Sep 2014 10:00:09 GMT

Hi ,

Try like this :

Table1:

LOAD * INLINE [

Country

];

NoConcatenate

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

drop table Table1;

Thanks !!

sujeetsingh — Fri, 05 Sep 2014 10:00:34 GMT

Load*

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

qlikmsg4u — Fri, 05 Sep 2014 10:00:55 GMT

YOU CAN USE where condition while loading the data.

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

MayilVahanan — Fri, 05 Sep 2014 10:12:46 GMT

Try like this

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