The Abort step can be used to stop a transformation based on the input data. This step is especially useful for error handling. For example, you can use this step so that a transformation will stop processing at a specified number of rows after it detects an error.
The Abort transformation step features the following fields.
|Step Name||Specifies the unique name of the transformation step on the canvas. The Step Name is set to ‘Abort’ by default.|
|Abort threshold||Enter the number of rows, after an error is detected, at which to abort the transformation. For example, if the threshold is set to ‘0’, the Abort step will stop the transformation after processing the first row. If the threshold is set to ‘5’, then the Abort step will stop the transformation after processing the sixth row.|
|Abort message||Enter the message for the log when aborting the transformation. If blank, a default message is used|
|Always log rows||Select this check box to always log the rows processed by the Abort step. The rows will be logged although the log level of the transformation would normally not log them. By selecting this check box, you can always see in the log which rows caused the transformation to abort.|
|Abort with error||When this check box is selected, and the Abort step stops the transformation, the event is reported as an error. This option can be useful when a parent step (such as the Kafka Consumer step) executes a sub-transformation which contains the Abort step.|
When finished, select OK to save your selections or Cancel to close the dialog box without saving.