Get Data Row

Get Data Row

Type: get-row  ·  Package: DataTable Activities v1.0.0  ·  Output: DataRow

Returns the row (DataRow) at a specific position of a DataTable.

How it works

Reads the row at position index (the first is 0) and returns it. If the index is out of range, it fails with a clear message. It does not modify the table.

With the row you can read cells with Get Cell or modify it with Set Cell / Update Data Row — remember the row is still bound to its table, so modifying it changes the table.

Required parameters

Parameter	Editor	Description
table	expression	The DataTable to read from, e.g. = customers.
index	expression	Row index (zero-based).

Optional parameters

None.

Output

Returns a DataRow.

Example

Get Data Row   table = = people   index = 0   → output: first

Set Cell   row = = first   column = "age"   value = 99
Log   message = = "Name: " + str(first["name"])

Loop the whole table

To process all rows, use For Each over the table instead of Get Data Row by index. Get Data Row is for accessing a specific row (the first, the last with = rowCount(t) - 1, etc.).

Related activities

• Get Cell — read a cell of the row.
• For Each — loop through all rows.
• Find Data Row — get a row by condition instead of index.