Clear DataTable

Clear DataTable

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

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

Modifies the table in place

Removes the rows from 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. The columns, their names and types are kept, so you can reuse the table with Add Data Row.

Required parameters

Parameter	Editor	Description
table	expression	The DataTable to clear, e.g. = buffer.

Optional parameters

None.

Output

None — modifies the table in place.

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 }

Related activities

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