Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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 !!
Load*
from table where wildmatch(Country,'a','b','c')<>1
YOU CAN USE where condition while loading the data.
Where not match(country, 'a','b','c')
Hi
Try like this
Load * from table where not match(Country,'a','b','c');