There might be a time when you only need to apply a zero fill to one column. This can be accomplished using an Edit Column step in the Pipeline.
After the Edit Column step, follow these steps:
- Select the column to which you want to add zero fill.
- Select the formula type as Custom formula.
- Enter the case statement as the formula:
CASE WHEN “column name” IS NULL THEN 0 ELSE “column name” END