Added by Matt Casters, last edited by Roland Bouman on Mar 21, 2014  (view change)

Labels:

Enter labels to add to this page:
Wait Image 
Looking for a label? Just start typing.

Detect empty stream

This step will output one row if input stream is empty (ie when input stream does not contain any row). The output row will have the same fields as the input row, but all field values will be empty (null).

If the input stream is not empty it will not output anything.

Options

Option Description
Step name Name of the step. This name must be unique throughout the transformation

The following design ensures always a row and can set default values when a stream is empty (sample transformation attached):