Get Data Column

get the column values of data table.

Get column values using column name or column index from the data table and store them into a list variable.

Input

• Input : DataTable Variable The Data Table to get column values.
• Column Name : DynamicSearchString The name of the column to get values. If this property is set then the Column Index property is ignored.

  • Text - The full name of the column to be sorted.

  • Regex - The regex is used to find matching column names to be sorted.

  • Wildcard - The character that is used for search matching column name. The asterisk (*)and the question mark (?) are used as wildcard characters. The asterisk represents zero or more characters in a string. The question mark represents any one character.

When multiple matches are found while using Search Methods, only the first match is considered.

The Text, Regex and Wildcard search methods are supported.EditDistance is not supported.

• Column Index : Object Argument The index of the column to get values. If this property is set then the Column Name property is ignored.

Output

• ColumnValues : List Object Variable The output variable stores the column values.