Check Column Existence#

Checks for the existence of a column in a table.

Table[Data Table] The data table in which the column is checked.
Column Name[Text] The name of the column.
Case SensitiveIf this property is enabled, the case of characters will be considered during the check; otherwise, it will be ignored.
Check Type

Select the type of check.

Possible values:

  • "Include" - the column must be present in the table;
  • "Exclude" - the column must not be present in the table.
Column Number[Number] The number of the found column
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.

Error Output Direction

Select the output direction from the block when an error occurs. Possible values:

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

This property allows you to determine the output direction when errors occur for blocks that do not contain the "If Error" connector (e.g., 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" - by default;
  • "Release" - output is 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 Message[Text] Returns detailed information about the error in case of incorrect execution of the block's work.