topic Re: removing null values from data through script in QlikView

removing null values from data through script

Tue, 26 Jun 2012 06:12:47 GMT

t1:

load * inline[

name, salary

a,12

b,1232

c,24314

d,2144

e,2134

f,435665

,6878

]

where isnot null(Name);

I have written this code, but still my null values are coming.

So please help me out.

Re: removing null values from data through script

giakoum — Tue, 26 Jun 2012 06:28:35 GMT

[temp]:

LOAD * INLINE [

name, salary

a, 12

b, 1232

c,24314

d,2144

e,2134

f,435665

,6878

];

NoConcatenate [temp1]:

load * Resident [temp] where not isnull(name) and name <> '';

DROP Table [temp];