Zero fill columns

Data Pipeline

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:

  1. Select the column to which you want to add zero fill.
  2. Select the formula type as Custom formula.
  3. Enter the case statement as the formula:
    CASE WHEN “column name” IS NULL THEN 0 ELSE “column name” END

Related Data Pipeline Help Articles

See more