Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
r20017aaa
Contributor III

replace null in load script

how via script load to replace null with 'Other'

LOAD * INLINE [
NAME, GRADE
A, 100
B,
C, 90
D
]
;

so looking for

Name Grade

A      100

B      Other

C      90

D      Other

1 Solution

Accepted Solutions

Re: replace null in load script

May be this

LOAD NAME,

    If(Len(Trim(GRADE)) = 0, 'Other', GRADE) as GRADE;

LOAD * INLINE [
NAME, GRADE
A, 100
B,
C, 90
D
];

1 Reply

Re: replace null in load script

May be this

LOAD NAME,

    If(Len(Trim(GRADE)) = 0, 'Other', GRADE) as GRADE;

LOAD * INLINE [
NAME, GRADE
A, 100
B,
C, 90
D
];