Remove a row from load

[renjithpl]

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

[Anonymous · Accepted solution]

You could use a where condition on your load with:

Where len(COTYPE_SPPRSD)>0;