Null as value

[Anonymous]

Hello Guys,

How can I put 0% for all rows in my table.

[BrunPierre]

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;