ISMISMATCHED Function

D toc

Excerpt
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.

Info
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

snippet	Basic

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

snippet	Syntax

D code
derive type:single value:ISMISMATCHED(column_string,datatype_literal)

Argument	Required?	Data Type	Description
column_string	Y	string	Name of column or string literal to be applied to the function
datatype_literal	Y	string	String 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

snippet	usage

Required?	Data Type	Example Value
Yes	String literal or column reference	`myColumn`

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

D s

snippet	usage

Required?	Data Type	Example Value
Yes	String literal	`'Integer'`

Valid data type strings:

Include Page

	Valid Data Type Strings
	Valid Data Type Strings

D s

snippet	Examples

Include Page

	EXAMPLE - Type Functions
	EXAMPLE - Type Functions

D s also

label	type

Versions Compared