En

Check for Value Existence#

Checks for the existence of a value in the entire table or in a specified column.

Table[Data Table] The data table in which the value is checked.
Value[Text/Number] The value being checked in the table.
Column[Number/Text] The column number or name. If left empty, the check will be performed across the entire table. Numbering starts from 0.
Whole Word

Word boundaries will be considered during the search.

For example, with this property enabled, the value "Value" will be found in the text "This Value", but will not be found in the text "This ValueTest".

If the property is disabled, the value "Value" will be found in both examples.

Check Type

Select the type of check. Possible values:

  • "Include" - the value must be present in the table;
  • "Exclude" - the value must not be present in the table.
Reverse CheckWhen checking, swap the input values. When this property is enabled, the presence of values from the table will be checked in the specified property "Value".
Extended Check

If enabled, the check will use wildcards (Wildcard). For example: "test*", "te?t".

If the property is disabled, the check will be performed in a simple way and will be faster.

Case SensitiveIf this property is enabled, case sensitivity will be considered during the check; otherwise, it will be ignored.
Row Number[Number] The row number of the cell where the value was found.
Column Number[Number] The column number of the cell where the value was found.
Error Handling Level

Select the error handling level. Possible values:

  • "Default" - default;
  • "Ignore" - errors are ignored;
  • "Handle" - errors are handled.

If "Default" is selected, the value from the "Start" block of this diagram will be used.

Error Output Direction

Select the output direction from the block in case of an error. Possible values:

  • "Default" - default;
  • "Right" - to the right;
  • "Bottom" - down.

This property allows you to determine the output direction in case of errors for blocks that do not contain the "If Error" connector (for example, the "Condition" block).

If "Default" is selected, the value from the "Start" block of this diagram will be used.

Message Level

Select the message level that the blocks will output during operation. Possible values:

  • "Default" - default;
  • "Release" - output disabled;
  • "Debug" - main information output;
  • "Detailed" - detailed information output.

If "Default" is selected, the value from the "Start" block of this diagram will be used.

Error Text[Text] Returns detailed information about the error in case of incorrect execution of the block's work.