topic [HELP] how to prevent load rows that include certain character ? in QlikView

[HELP] how to prevent load rows that include certain character ?

Wed, 01 Dec 2010 14:29:35 GMT

helloo....

i ned a help

i have loaded a table to qlikview

but there's a column with unright data

example : -column1row1

n what i wanna ask is, how to prevent load data that include minus ( - ) character in first character of words?

thx,,,,

renjithpl — Wed, 01 Dec 2010 14:34:42 GMT

if it is only values,

then use

Fabs(column1) as column1

REgards

Wed, 01 Dec 2010 14:59:49 GMT

no it's not

there r some other unright data

such as NULL786

which is i do not want any field that contain NULL to be loaded

is there any way?

many thx..

renjithpl — Wed, 01 Dec 2010 21:28:07 GMT

please send a sample table of -column1

Anonymous — Wed, 01 Dec 2010 22:00:00 GMT

not sure exactly till the time get to see the exact table structure.

You can try using like function which returns boolean values and the n put the condition.

--Swapnil