{{ transformations:HaltOnTypeMismatchAction.png}}
====== 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 [[syntax:types|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 [[syntax:types#empty_values|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:breakpoint|Breakpoint]]
  * [[transformations:halt|Halt on condition]]
  * [[transformations:wait|Wait]]
  * [[syntax:types|Data types in EasyMorph]]