Get Data Column
get the column values of data table.
Last updated
get the column values of data table.
Last updated
Get column values using column name or column index from the data table and store them into a list variable.
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.
ColumnValues : List Object Variable
The output variable stores the column values.