Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
How can I put 0% for all rows in my table.
Hi @Anonymous
This expression changes all of a field's NULL values to "0.00%.".
Coalesce(Field,'0.00%')
or
Perhaps with a NullAsValue statement as below.
NullAsValue Field;
Set NullValue = '0.00%';
LOAD Field FROM SourceTable;