If Null Or Empty String

If Null Or Empty String transformation function

Key Value
Category Transformation Function
Description Checks if the data is Null or Empty String. (Length of the string is zero).
Properties None

Usage example

Customer Question

  1. I read a column from my reader (input)
  2. When the value is not null (string) then load the data in the designated writer field
  3. When the value is null (empty string) then load the data from another input field

Working Solution

If Null transformation function usage example

Back to Working with Transformer

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum

Posted on June 16, 2026 • 1 min read • 110 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License