Tests whether a set of values is not valid for a specified data type.

You can define a conditional test in a single step for valid values. See IFMISMATCHED Function.

NOTE: This function is similar to the ISVALID function, which tests for validity against a specified data type. However, unlike the ISVALID function, the ISMISMATCHED function also matches against missing values. See VALID Function.

Column reference example:

ismismatched(Qty, 'Integer') || (Qty < 0)

Output: Returns true when the value in the Qty column does not contain a valid Integer and the value is less than zero.

Numeric literal example:

ismismatched('ZZ', 'State')

Output: Returns true, since the value ZZ is not a valid U.S. State code.

ismismatched(column_string,datatype_literal)


ArgumentRequired?Data TypeDescription
column_stringYstringName of column or string literal to be applied to the function
datatype_literalYstringString literal that identifies the data type against which to validate the source values

column_string

Name of the column or string literal to be evaluated for mismatches against the specified type.

Required?Data TypeExample Value
YesString literal or column referencemyColumn

datatype_literal

Literal value for data type to which to validate the source column or string.

Required?Data TypeExample Value
YesString literal'Integer'

Valid data type strings:

Example - Type check functions