Clear DataTable

Clear DataTable

Type: clear-datatable  ·  Package: DataTable Activities v1.0.5  ·  Output: none

Empties a DataTable: removes all its rows but keeps its columns (the schema).

Modifies the table in place

Deletes the rows of the original table — it does not return a copy. After the operation, the table has 0 rows but the same columns, ready to be filled again.

How it works

Removes every row from the table. Columns, their names and types are kept, so you can reuse the table with Add Data Row. Clearing a table that already has no rows is not an error: nothing changes. The run log states how many rows were removed.

DataRow objects you stored earlier in variables no longer belong to the table; don’t reuse them after clearing it.

Required parameters

Parameter	Type	Default	Description
table	DataTable	—	The DataTable to clear, e.g. buffer.

Optional parameters

None.

Output

This activity does not return a value; it modifies the table in place.

Common errors

Message	Cause and fix
'table' must be a DataTable.	table does not evaluate to a DataTable (empty variable or another type).

Example

Reuse a table as a buffer inside a loop:

Clear DataTable   table = buffer

For Each   items = batch   itemVariable = item
 └─ activities:
      Add Data Row   table = buffer   values: { id: item.Id, total: item.Total }

Write Excel Sheet   path = "C:/out/batch.xlsx"   data = buffer

Related activities

• Add Data Row — fill the table again.
• Remove Data Row — remove a single row.
• Build DataTable — create a table from scratch.