Find Row#

Search is performed on the table by comparing with the specified value and returns the first matching row.

Table[Data Table] The data table in which the row is searched.
Search Value[Text/Number] The value being searched in the table. If the "Compare as strings" property is enabled, wildcard characters can be specified.
Column[Number/Text] The number or name of the column in which the value is checked. If an empty value is specified, the check will be performed across the entire table. Numbering starts from 0.
Compare as stringsWhen enabled, the values for comparison will be converted to strings.
Case sensitive

If the property is enabled, the case of characters will be taken into account during the check; otherwise, it will be ignored.

Used only if the "Compare as strings" property is enabled.

Row[Link] Returns a link to the row with the found value.
Row number[Number] The number of the row where the value was found. Numbering starts from zero.
Column number[Number] The number of the column where the value was found. Numbering starts from zero.
Error handling level

Select the error handling level. Possible values:

  • "Default" - by 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.

Message level

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

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

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

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