This is an old revision of the document!
Halt on condition
This transformation aborts project execution if specified condition is not fulfilled. Error message can be customized to provide more insight into the cause of interruption.
The purpose of this transformation is to monitor data quality and prevent project from producing incorrect results or exporting incorrect data.
Example
Let's assume we expect amounts to be only numbers.
Before transformation:
| Province | Amount | Total Tax |
|---|---|---|
| ON | 1000 | 125 |
| BC | #N/A | 187.5 |
| QC | 2000 | 270 |
Defining condition as follows
isnumber([Amount])
will make the transformation stop project execution, because one of the values in column Amount is not number.
Note that the condition should return either TRUE or FALSE for all rows. If for some reason it returns error then the transformation will also fail.
See also: