Switch Job

image_pdfimage_print

With this job, you can build an execution chain based on conditions. A different load or subjob is executed depending on the value of a dynamical, data-driven condition, as in an IF or CASE statement of a programming language.

There are two modes of conditions:

Switch on Source: the condition is the value of any extract or transform in a particular column or row. A data source, the name of a column of the source and a row index (default: first row) has to be specified. In the easiest case the data source contains only one column and one row.

Switch on Job Status: the condition is the result code of another job execution. In this case the only possible values are “statusOK”, “statusWarnings” and “statusErrors”. Note that this job should have the “Fail on status” set to “none”, otherwise the execution might terminate before the switch condition is applied in case of “statusWarnings” or “statusError”.

Switch conditions can be defined as follows:

Filter type

accept:

All nodes that fulfill the filter criteria are included in the selection.

deny:

All nodes that fulfill the filter criteria are excluded from the selection.

Operator

equal:

Only the specified elements are filtered. Example: Austria

inAlphaRange:

Alphanumerical values in a particular range are filtered. Examples:

inclusive Range: “[A100,A200]”
exclusive Range: “(A100,A200)”
half-open interval: “[A100,)”
half-open interval: “(,A100)”

inRange:

Numerical values in a particular range are filtered. Examples:

inclusive Range: “[100,200]”
exclusive Range: “(100,200)”
half-open interval: “[100,)”
half-open interval: “(,100)”

isEmpty:

Empty values (blank, space or multiple space values).

like:

Filters the dimension elements according to regular expressions.

Value

 

Execute job

A job that is executed if the condition applies.

If the condition value matches one of these switch conditions, the corresponding job is executed. A default job can be defined that is executed if none of the switch conditions matches.

image_pdfimage_print
Was this post helpful?
NoYes (-1 rating, 1 votes)
Loading...