Developer.Datatable
Description
Searches for a specific value in a DataTable column. The found rows are saved in an array of type System.Data.DataRow.
Properties
Analyst
- Description: Optional text for documentation purposes.
Common
-
Disable Log: Disables the logging functionality for this activity.
-
Disable Protocol: Disables the protocol functionality for this activity.
Input
- Column: The column that is searched for the provided search term, passed as a System.Data.DataColumn.
-
ColumnIndex: The
index of the column that is searched for the provided search term. Handed over
as an integer, starting at 0 (variable or static). Note: To avoid providing inconsistent information, you can use only one of the property fields - Column, Column Index, or Column Name.
- ColumnName: The column name that is searched for the provided search term, passed as variable or static string .
- Compare Operator: The search method for the search value, such as EqualTo (search value must be found exactly) or Like (the row must contain the search value, but can contain more information).
- DataTable: The DataTable to investigate.
- Search Value: The value that the specified column is searched for, passed as variable or static string.
Output
- Data Row(s) Found: The List of DataRows which were found with the search value. Output type: System.Data.DataRow[].
Example
An excel sheet was saved into a DataTable. The information should be updated with information from SAP. With Find in Table the right row is selected and afterwards updated with Set Cell Value Table.
Tips and Tricks
- The array of DataRows contains the whole row, not only a single position or value.
- The output can be used to delete specific rows in a DataTable or to update a column in the found rows
Troubleshooting
- Core.Activities.Exceptions.InputArgumentsValidationException: Error in input arguments. Please verify if each input is set correctly!: The DataTable is not initialized. Please use a Create Table or Read Range activity before using the Add Table Row.
- Data.EvaluateException: Cannot find column [Test]: The column to search in was not found in the DataTable. A spelling mistake in the property field Column Name might be the reason.
- IndexOutOfRangeException: Cannot find column 20: The index of the column to search in is out of range. Consider that the index starts at 0, the 20th column would be index 19 then.