User Tools

Site Tools


transformations:halt

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
transformations:halt [2015/10/02 02:18]
dmitry
transformations:halt [2020/02/14 08:51] (current)
dmitry
Line 1: Line 1:
 ===== 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**
  
-Let's assume we expect amounts to be only numbers.+Let's assume we expect amounts to be numbers in all rows.
  
 Before transformation: Before transformation:
Line 15: Line 15:
 |  QC  |    2000| 270| |  QC  |    2000| 270|
  
-Defining condition as follows +Defining condition as follows 
-   isnumber([Amount]) +   not 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. Iffor some reasonit 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]]
transformations/halt.1443752301.txt.gz · Last modified: 2015/10/02 02:18 by dmitry