Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | Next revisionBoth sides next revision |
| transformations:halt [2015/10/01 22:18] – 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 each row. 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:** | **See also:** |
| * [[syntax:errorpropagation| Error propagation in expressions]] | * [[syntax:errorpropagation| Error propagation in expressions]] |
