topic replace null in load script in QlikView

replace null in load script

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

sunny_talwar — Wed, 25 Apr 2018 16:45:04 GMT

May be this

LOAD NAME,

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

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