Remove a row from load

renjithpl — Wed, 05 Dec 2012 06:50:34 GMT

Hi All,

I have a table like this, but i need to delete only one row from load script, without disturbing other rows,

I was not asked to use IF condition, using if condition and resident function i can remove, but is there any other way of doing this, may be using exists function, as i am not familiar using exists..

USER_GROUP	COUNTRY_CODE	COTYPE_SPPRSD
GEO	GE	HO Ctry
GEO	GE	Hyper
GEO	GE	Srv Ctr
GCC_ALL	AE
GCC_ALL	AE	HO Ctry
GCC_ALL	AE	Hyper
GCC_ALL	AE	Srv Ctr
GCC_ALL	AE	Super
GCC_ALL	AE	Web
GCC_ALL	BH	HO Ctry

the row in red font....

regards

ren

Re: Remove a row from load

Anonymous — Wed, 05 Dec 2012 07:02:48 GMT

You could use a where condition on your load with:

Where len(COTYPE_SPPRSD)>0;

topic Remove a row from load in QlikView

Remove a row from load

Re: Remove a row from load