Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Want to change on Script Side and not In Expression.
1) Tried changing Setnullasvalue;
2) Tried IF (Isnull(Name), ' NoName', 'Name')
Unable to replace nullvalues with 'NoName'
Any Help Plz.
Hello,
Try instead
If(Len(Trim(Field)) > 0, Field, 'Empty') AS Field, // note that Field is the field name (and no quoted) and 'Empty' is a string
Hope this helps.
if(Name = '', Field,'No_Data') as Name