Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
LOAD NAME,
If(Len(Trim(GRADE)) = 0, 'Other', GRADE) as GRADE;
LOAD * INLINE [
NAME, GRADE
A, 100
B,
C, 90
D
];
May be this
LOAD NAME,
If(Len(Trim(GRADE)) = 0, 'Other', GRADE) as GRADE;
LOAD * INLINE [
NAME, GRADE
A, 100
B,
C, 90
D
];