User Tools

Site Tools


transformations:haltontypemismatch

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

SettingDescription
Data type Desired/Not DesiredSelect whether the selected data type is desired or not desired in the selected columns.
Data typeSelect the data type being checked for. Options: Text, Number/date, Boolean, or Error.
Empty valuesSelect whether empty values are acceptable or not. Options: Empty values are OK or Empty values
are NOT OK
.
Columns to checkSelect 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/07/19 02:05 by craigt