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

You can use the ISVALID function keywords interchangeably.

Column reference example:

keep row:(ISVALID(Qty, 'Integer') && (Qty > 0))

Output: Keeps any row in which the value in the Qty column contains a valid Integer and the value is greater than zero. 

Numeric literal example:

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

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

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


Name of the column or string literal to be evaluated for validity.

Required?Data TypeExample Value
YesString literal or column referencemyColumn


Literal value for data type to which to match the source column or string. For more information, see Valid Data Type Strings.

Required?Data TypeExample Value
YesString literal'Integer'

Valid data type strings:

Example - Type check functions