Lookup Datatable

This activity allows the user to search for a specific value within a provided DataTable and retrieve the corresponding value from a specified target column in the same row.

Properties

Input

DataTable: *Specifies the input DataTable from which the lookup operation will be performed.

Lookup Value: *Specifies the value to be searched within the specified lookup column. Accepts values in String datatype

Lookup Column

The properties below let you specify the column to search the value from. Provide any one of the following.

Column: Specifies the DataColumn object where the column name is stored. Accepts values in DataColumn datatype.

Column Name: *Specifies the name of the column in which the lookup needs to be performed. Accepts values in String datatype.

Column Number: Specifies the index position of the column within the input DataTable. Accepts values in Int32 datatype. The index position starts from

Target Column

The properties below specify the target column from which the value should be retrieved for the matched lookup value. Provide any one of the following.

Column: Specifies the DataColumn object where the target column name is stored. Accepts values in DataColumn datatype.

Target Column Name: *Specifies the name of the column from which the value should be retrieved. Accepts values in String datatype.

Column Number: Specifies the index position of the target column within the input DataTable. Accepts values in Int32 datatype. The index position starts from 0.

MISC

Display Name: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”

True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

Output

Cell value: Returns the value retrieved from the corresponding target column for the specified lookup value. The output is returned in String datatype.

Row Index: Returns the row index of the identified cell value from the target column. The output is returned in Int32 datatype.

Result: This parameter allows you to view the execution status of the activity and returns a value in “Boolean.”

True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown

* Represents mandatory fields to execute the workflow.