Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc

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

  • For a tested value, this function returns true or false
  • Inputs can be literal values or column references.

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.

D s

Column reference example:

D code

delete row:(ISMISMATCHED(Qty, 'Integer') || (Qty < 0))

Output: Deletes any row in which the value in the Qty column does not contain a valid Integer and the value is less than zero. 

Numeric literal example:

D code

derive type:single value: ISMISMATCHED('ZZ', 'State')

Output: Generates a new column containing true, since the value ZZ is not a valid U.S. State code.

D s

D code

derive type:single value: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

D s lang notes


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

  • Missing literals or column values generate missing string results.
    • Constants must be quoted ('Hello, World').
  • Multiple columns and wildcards are not supported.

D s

Required?Data TypeExample Value
YesString literal or column referencemyColumn


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

  • Column references are not supported.

D s

Required?Data TypeExample Value
YesString literal'Integer'

Valid data type strings:

Include Page
Valid Data Type Strings
Valid Data Type Strings

D s

Example - Type check functions

Include Page
EXAMPLE - Type Functions
EXAMPLE - Type Functions

D s also