Comparison conditions

Data type list

The conditions that you can use depend on the data type.

There may also be cases where the results vary depending on the data type depending on the conditions.

String type

This type recognizes the input value as string.

Numeric type

This type recognizes the input value as numeric.

If there are alphabetic characters, symbols, or so on that can't be converted to numbers, an error occurs.

Date/Time type

This type recognizes the input value as date/time.

If it can't be converted based on date format, an error occurs.

Boolean type

This type recognizes the input value as boolean.

If input values aren't "true", they're all "false".

Value condition list

Condition name	Description	Available data types	Example of success	Example of error	Remarks
Equal	If the input value and expected value match, it's successful. Note Null and empty string are handled as the same value.	String Number Date/Time Boolean	Expected value Input value ABC ABC 123 123	Expected value Input value EDF ABC 456 123
Not equal	If the input value and expected value don't match, it's successful. Note Null and empty string are handled as the same value.	String Number Date/Time Boolean	Expected value Input value EDF ABC 456 123	Expected value Input value ABC ABC 123 123
Forward match	If the first part of the input value and expected value match, it's successful.	String	Expected value Input value AB ABC 12 123	Expected value Input value BC ABC 23 123
Backward match	If the last part of the input value and expected value match, it's successful.	String	Expected value Input value BC ABC 23 123	Expected value Input value AB ABC 12 123
Regular expression	If the input value matches the regular expression pattern of the expected value, it's successful.	String	Expected value Input value A.* ABC \d+ 123	Expected value Input value ^BC ABC \d+ ABC
Any value	Regardless of the input value and expected value, it's successful. = Remarks = The expected value isn't used.	String Number Date/Time Boolean	Expected value Input value   ABC 456 123	No error example.	Note Not available in Compare Variable operation.
Empty string or null	If the input value is empty string or null, it's successful. = Remarks = The expected value isn't used.	String	Expected value Input value   (null value)   (empty string)	Expected value Input value   ABC   123	Note Not available in Compare Variable operation.
Empty string	If the input value is empty string, it's successful. = Remarks = The expected value isn't used.	String	Expected value Input value   (empty string)	Expected value Input value   (null value)   ABC	Note Not available in Compare Variable operation.
null	If the input value is null, it's successful. = Remarks = The expected value isn't used.	String Number Date/Time Boolean	Expected value Input value   (null value)	Expected value Input value   (empty string)   ABC	Note Not available in Compare Variable operation.
Not less than (On or after)	If the input value is not less than the expected value, it's successful. In the case of string, it's compared with Unicode order.	String Number Date/Time	Expected value Input value 100 100 100 150 1/1/2017 1/1/2018 ABC ABD	Expected value Input value 100 50 1/1/2017 1/1/2016 ABC ABB
Not more than (On or before)	If the input value is not more than the expected value, it's successful. In the case of string, it's compared with Unicode order.	String Number Date/Time	Expected value Input value 100 100 100 50 1/1/2017 1/1/2016 ABC ABB	Expected value Input value 100 150 1/1/2017 1/1/2018 ABC ABD
Type match	If the input value can be analyzed as that type, it's successful. = Remarks = The expected value isn't used.	Number Date/Time	Expected value Input value (numeric type) 100 (date type) 1/1/2017	Expected value Input value (numeric type) ABC (numeric type) 1/1/2017 (date type) EFG (date type) 123	Note Not available in Compare Variable operation. Not available in value conditions for Compare Table Model operation.

Row condition list

Order-sensitive

If the row for the input value and the row for the expected value match exactly, it's successful.

If the number of rows is different, or if the comparison of the values is different, an error occurs.

Example of execution

The conditions for values are assumed to be defined as Equal for all columns.

• Input value

  String	Numeric string
  AAA	123
  BBB	456

Successful pattern

• Expected values (matches exactly including order that rows appear)

  String	Numeric string
  AAA	123
  BBB	456

Unsuccessful pattern

• Expected values (values match exactly but order that rows appear is different)

  String	Numeric string
  BBB	456
  AAA	123

Order-insensitive

The rows for the input values and the rows for the expected values match.

Even if the order that the rows appear is different, if the values for each row match, it's successful.

Example of execution

The conditions for values are assumed to be defined as Equal for all columns.

• Input value

  String	Numeric string
  AAA	123
  BBB	456

Successful pattern

• Expected values (matches exactly including order that rows appear)

  String	Numeric string
  AAA	123
  BBB	456

• Expected values (values match exactly but order that rows appear is different)

  String	Numeric string
  BBB	456
  AAA	123

Error pattern

• Expected values (number of rows is different)

  String	Numeric string
  AAA	123
  BBB	456
  CCC	789

• Expected values (values of rows are different)

  String	Numeric string
  CCC	789
  AAA	123

Appear

If all rows for the expected values appear in the rows of the input values, it's successful.

Example of execution

The conditions for values are assumed to be defined as Equal for all columns.

• Input value

  String	Numeric string
  AAA	123
  BBB	456

Successful pattern

• Expected values (matches exactly including order that rows appear)

  String	Numeric string
  AAA	123
  BBB	456

• Expected values (values match exactly but order that rows appear is different)

  String	Numeric string
  BBB	456
  AAA	123

• Expected values (the number of rows for expected values is smaller than for input values, but expected rows exist in the rows for the input values)

  String	Numeric string
  BBB	456

Error pattern

• Expected values (rows for the expected values don't appear in the rows for the input values)

  String	Numeric string
  CCC	789