Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision |
transformations:halt [2015/10/01 22:16] – created dmitry | transformations:halt [2020/02/14 03:48] – dmitry |
---|
===== Halt on condition ===== | ===== 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. | This action 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. | The purpose of this action is to monitor data quality and prevent projects from producing incorrect results or exporting incorrect data. |
| |
**Example** | **Example** |
| QC | 2000| 270| | | QC | 2000| 270| |
| |
Defining condition as follows | Defining a condition as follows |
isnumber([Amount]) | isnumber([Amount]) |
will make the transformation stop project execution, because one of the values in column Amount is not number. | will make the action 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. | ===Notes=== |
| The condition must return either TRUE or FALSE for each row. If, for some reason, it returns an error then the action will also fail. |
| |
| If the condition is global (i.e. doesn't refer any field) then it's still evaluated even if the dataset is empty. |
| |
| **See also:** |
| * [[syntax:errorpropagation| Error propagation in expressions]] |