Sometimes a column returns null values. By using the Oracle SQL function NVL, null values can be replaced with another value.
Note: The following example only applies to data retrieved from an Oracle database.
To modify a column to replace null values with 0 (zero):
Right-click on the column in the Elements tree.
Select Edit from the pop-up menu.
In the Expression
field, type:
NVL(%1,0)
Click Save.
Note: Sometimes a null value has a meaning different from zero, such as "value unknown". Make sure you understand how the data is meant to be interpreted before replacing values!