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

[#1]

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]

if it is only values,

then use

Fabs(column1) as column1

REgards

[#3]

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]

please send a sample table of -column1

[Anonymous]

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