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:

(isvalid(Qty, 'Integer') && (Qty > 0))

Output: Returns true when the value in the Qty column contains a valid Integer and the value is greater than zero. 

Column reference example for Datetime:


The Datetime data type requires a special formatting string as part of the evaluation of validity:

(isvalid(myDates, ['Datetime', 'yy-mm-dd hh:mm:ss','yyyy*mm*dd*HH:MM:SSX']))

Output: Returns true when the value in the myDates column conforms to either of the following date format strings:

yy-mm-dd hh:mm:ss
yyyy*mm*dd*HH:MM:SSX

For more information on these and other date format strings:

Numeric literal example:

isvalid('ZZ', 'State')

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

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

column_string

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

Required?Data TypeExample Value
YesString literal or column referencemyColumn

datatype_literal

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