Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to remove values in column in script?

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

5 Replies
Highlighted
Not applicable

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

Highlighted
Not applicable

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 !!

Highlighted
Master III
Master III

Load*

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

Highlighted
Specialist
Specialist

YOU CAN USE where condition while loading the data.

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

Highlighted

Hi

Try like this

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