Conditions

Data Types

Available conditions vary according to data types.
Also, some conditions' results vary according to data types.

String

Input value is handled as String.

Numeric

Input value is handled as Numeric.
When the value is one cannot be converted to number, such as alphabet or symbol, an error occurs.

Date/Time

Input value is handled as Date/Time.
When the value is one cannot be converted with the date formats, an error occurs.

For details on string presentations which can be converted to Date/Time, refer to Strings which can be set to Date type.

Boolean

Input value is handled as Boolean.
Except “true”, any input value is considered as “false”.

Value Conditions

Name

Description

Available data type

Success example

Error example

Remarks

Equal

It succeeds when an input value matches the expected value.

Null and empty string are handled as the same.

String
Numeric
Date/Time
Boolean

Expected value	Input value
ABC	ABC
123	123

Expected value	Input value
EDF	ABC
456	123

Not equal

It succeeds when an input value does not match the expected value.

Null and empty string are handled as the same.

String
Numeric
Date/Time
Boolean

Expected value	Input value
EDF	ABC
456	123

Expected value	Input value
ABC	ABC
123	123

Forward match

It succeeds when an input value forward matches the expected value.

String

Expected value	Input value
AB	ABC
12	123

Expected value	Input value
BC	ABC
23	123

Backward match

It succeeds when an input value backward matches the expected value.

String

Expected value	Input value
BC	ABC
23	123

Expected value	Input value
AB	ABC
12	123

Regular expression

It succeeds when an input value matches the expected regular expression.

String

Expected value	Input value
A.*	ABC
\d+	123

Expected value	Input value
^BC	ABC
\d+	ABC

Any value

It always succeeds regardless of input and expected value.

Expected value is not used.

String
Numeric
Date/Time
Boolean

Expected value	Input value
	ABC
456	123

None.

It is not available in Compare Variables.

Empty string or null

It succeeds when an input value is empty string or null.

Expected value is not used.

String

Expected value	Input value
	(null value)
	(empty string)

Expected value	Input value
	ABC
	123

It is not available in Compare Variables.

Empty string

It succeeds when an input value is empty string.

Expected value is not used.

String

Expected value	Input value
	(empty string)

Expected value	Input value
	(null value)
	ABC

It is not available in Compare Variables.

null

It succeeds when an input value is null.

Expected value is not used.

String
Numeric
Date/Time
Boolean

Expected value	Input value
	(null value)

Expected value	Input value
	(empty string)
	ABC

It is not available in Compare Variables.

Not less than (On or after)

It succeeds when an input value is not less than / on or after the expected value.
Strings are compared in the UNICODE collation.

String
Numeric
Date/Time

Expected value	Input value
100	100
100	150
2017/01/01	2018/01/01
ABC	ABD

Expected value	Input value
100	50
2017/01/01	2016/01/01
ABC	ABB

Not more than (On or before)

It succeeds when an input value is not more than / on or before the expected value.
Strings are compared in the UNICODE collation.

String
Numeric
Date/Time

Expected value	Input value
100	100
100	50
2017/01/01	2016/01/01
ABC	ABB

Expected value	Input value
100	150
2017/01/01	2018/01/01
ABC	ABD

Type match

It succeeds when an input data can be parsed as the type.

Expected value is not used.

Numeric
Date/Time

Expected value	Input value
(Numeric)	100
(Date)	2017/01/01

Expected value	Input value
(Numeric)	ABC
(Numeric)	2017/01/01
(Date)	EFG
(Date)	123

It is not available in Compare Variables.
It is not available in value conditions of Compare Table Model.

Row Conditions

Order-sensitive

It succeeds when input rows completely match the expected rows.
An error occurs when the number of rows differs or any of values doesn't match.

Example

All value conditions are assumed to be [Equal] in all columns.

Input value

String column Numeric column

AAA 123

BBB 456

String column	Numeric column
AAA	123
BBB	456

Success example

Expected value (completely matching, including the order of rows)

String column Numeric column

AAA 123

BBB 456

String column	Numeric column
AAA	123
BBB	456

Failure example

Expected value (matching but the order of rows differs)

String column Numeric column

BBB 456

AAA 123

String column	Numeric column
BBB	456
AAA	123

Order-insensitive

It succeeds when input rows match the expected rows.
Even when the order of rows differs, it succeeds if the values of rows match.

Example

All value conditions are assumed to be [Equal] in all columns.

Input value

String column Numeric column

AAA 123

BBB 456

String column	Numeric column
AAA	123
BBB	456

Success example

Expected value (completely matching, including the order of rows)

String column Numeric column

AAA 123

BBB 456

String column	Numeric column
AAA	123
BBB	456

Expected value (matching but the order of rows differs)

String column Numeric column

BBB 456

AAA 123

String column	Numeric column
BBB	456
AAA	123

Failure example

Expected value (the number of rows differs)

String column Numeric column

AAA 123

BBB 456

CCC 789

String column	Numeric column
AAA	123
BBB	456
CCC	789

Expected value (the values of a row differ)

String column Numeric column

CCC 789

AAA 123

String column	Numeric column
CCC	789
AAA	123

Appear

It succeeds when all expected rows appear in input rows.

Example

All value conditions are assumed to be [Equal] in all columns.

Input value

String column Numeric column

AAA 123

BBB 456

String column	Numeric column
AAA	123
BBB	456

Success example

Expected value (completely matching, including the order of rows)

String column Numeric column

AAA 123

BBB 456

String column	Numeric column
AAA	123
BBB	456

Expected value (matching but the order of rows differs)

String column Numeric column

BBB 456

AAA 123

String column	Numeric column
BBB	456
AAA	123

Expected value (expected rows are less than the input data and all the rows exist in the input rows)

String column Numeric column

BBB 456

String column	Numeric column
BBB	456

Failure example

Expected value (an expected row does not appear in input rows)

String column Numeric column

CCC 789