removing null values from data through script

[#1]

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.

[giakoum · Accepted solution]

[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];