Remove Data Row

Remove Data Row

Type: remove-row  ·  Package: DataTable Activities v1.0.0  ·  Output: none

Removes a row from a DataTable by its index (zero-based).

Modifies the table in place

Removes the row from the original table — it does not return a copy. After the operation, the table has one fewer row.

How it works

Removes the row at position index (the first row is 0). If the index is out of range, it fails with a clear message.

Required parameters

Parameter	Editor	Description
table	expression	The DataTable to modify, e.g. = customers.
index	expression	Index of the row to remove (zero-based).

Optional parameters

None.

Output

None — modifies the table in place.

Example

Remove Data Row   table = = people   index = 0

Log   message = = rowCount(people) + " rows left"

Careful when removing inside a loop

If you loop a table and remove rows at the same time, indexes shift. To delete several rows by condition, it’s usually safer to Filter DataTable (keep the ones you do want) instead of removing by index one by one.

Related activities

• Filter DataTable — keep the rows that meet a condition.
• Clear DataTable — empty all rows.
• Find Data Row — locate a row by condition.