transformations:haltontypemismatch
Table of Contents
HALT ON DATA TYPE MISMATCH
Category: Workflow / Internal
Description
This action halts project execution if a value from the specified column(s) has a wrong data type.
Use cases
The purpose of this action is to monitor data quality and prevent projects from producing incorrect results or exporting incorrect data.
Action settings
| Setting | Description |
|---|---|
| Data type Desired/Not Desired | Select whether the selected data type is desired or not desired in the selected columns. |
| Data type | Select the data type being checked for. Options: Text, Number/date, Boolean, or Error. |
| Empty values | Select whether empty values are acceptable or not. Options: Empty values are OK or Empty values are NOT OK. |
| Columns to check | Select whether the entire table will be checked, or just selected columns (and select the columns to check). |
Examples
Example: In the source table, we want to stop process execution if any non-numeric values appear in the "Amount" and "Total Tax" columns.
Source table:
| Province | Amount | Total Tax |
|---|---|---|
| ON | 1000 | 125 |
| BC | #N/A | 187.5 |
| QC | 2000 | 270 |
Action parameters:
The selected data type (below) will be "Desired"
The data type is "Number/date"
Select "Empty values are OK"
Select "Particular columns" and choose "Amount" and "Total Tax"
The process will stop due to the "#N/A" in row 2.
See also
transformations/haltontypemismatch.txt · Last modified: 2021/11/12 22:26 by craigt