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 revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
transformations:halt [2015/10/01 22:18] dmitrytransformations:halt [2020/02/14 03:51] 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.txt · Last modified: 2023/10/13 21:38 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki