Discussion board where members can get started with QlikView.
how via script load to replace null with 'Other'
LOAD * INLINE [ NAME, GRADE A, 100 B, C, 90 D ];
so looking for
Go to Solution.
May be this
If(Len(Trim(GRADE)) = 0, 'Other', GRADE) as GRADE;
LOAD * INLINE [NAME, GRADEA, 100B, C, 90D];