Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

removing null values from data through script

 

 

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.

1 Solution

Accepted Solutions
giakoum
Honored Contributor II

Re: removing null values from data through script

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

1 Reply
giakoum
Honored Contributor II

Re: removing null values from data through script

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

Community Browser