replace null in load script

[Anonymous]

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 · Accepted solution]

May be this

LOAD NAME,

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

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