Lookup Data Table

Searches for a value in a column and retrieves the target cell value and row index.

Behaviour

Risk: None · Idempotent: Yes · Safe to retry: Yes · Recovery: Not replayed after a crash

Package System activities VeloPhex.System.Activities 0.7.1-rc.12 · Supported (Core profile) · type id velophex.system.lookupDataTable

Properties#

Input#

Data Table#

DataTable · DataTable · Required · Default: Not specified in package metadata

The DataTable to search in.

Lookup Value#

LookupValue · Object · Required · Default: Not specified in package metadata

The value to find in the lookup column.

Lookup Column Name#

LookupColumnName · String · Optional · Default: Not specified in package metadata

The name of the column to search in. Takes precedence over LookupColumnIndex.

Lookup Column Index#

LookupColumnIndex · Int32? · Optional · Default: Not specified in package metadata

The zero-based index of the column to search in.

Target Column Name#

TargetColumnName · String · Optional · Default: Not specified in package metadata

The name of the column to retrieve the result from. Takes precedence over TargetColumnIndex.

Target Column Index#

TargetColumnIndex · Int32? · Optional · Default: Not specified in package metadata

The zero-based index of the column to retrieve the result from.

Output#

Cell Value#

CellValue · Object · Output

The cell value found in the target column.

Row Index#

RowIndex · Int32 · Output

The zero-based row index where the value was found, or -1 if not found.

Retry and risk#

This activity is safe to retry: running it again after a transient failure does not repeat a side effect. If a run is interrupted and the outcome of a step is unknown, the step is never retried automatically (what to do). How activities declare this: characteristics, retries and risk.

Every activity also has the engine's common properties: Timeout and Continue On Error.

Related activities#

• Add Data Column
• Add Data Row
• Build Data Table
• Clear Data Table
• Filter Data Table
• Generate Data Table From Text
• Get Row Item
• Join Data Tables

Generated from VeloPhex.System.Activities 0.7.1-rc.12. Category: Data Table. Keywords: datatable, lookup, search, find, vlookup, index.

Properties

Input

Output

Retry and risk

Related activities