Filter DataTable

Filter DataTable

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

Filters a DataTable and returns a new table with only the rows that meet the conditions. It is the most common operation when processing data: keeping the pending ones, those greater than an amount, those of a client. Supports multiple conditions combined with AND (all) or OR (any) logic.

How it works

Evaluate each row against the conditions. In the Designer, the conditions are created with a visual editor: for each one you choose a column, an operator and a value, and define whether they are combined with AND or OR. It returns a new table with the rows that pass the filter.

Required parameters

Parameter	Editor	Description
table	expression	The DataTable to filter.
conditions	editor de condiciones	One or more conditions (column · operator · value) with AND/OR logic.

Optional parameters

Ninguno.

Operadores disponibles

Operador	Significado
equals / not-equals	Igual / distinto
contains	Contains the text
starts-with / ends-with	Starts/ends with
greater-than / less-than	Greater/less than (numeric)
greater-or-equal / less-or-equal	Greater-equal / lesser-equal (numeric)
is-empty / is-not-empty	Empty/non-empty cell

Output

Returns a DataTable with the matching rows. The rest are discarded (the original table is not modified).

Example

Keep invoices pending and greater than 1,000,000:

Filter DataTable
  table = = facturas
  conditions:
     Estado equals "Pendiente"   Y
     Total  greater-than 1000000
  → output: importantes

Log   message = = "Filas que cumplen: " + rowCount(importantes) + " de " + rowCount(facturas)

Filtro complejo → LINQ

The condition editor covers most cases. For more elaborate logic (nested AND/OR combinations, calculations), filter with LINQ in an expression: = asRows(facturas).Where(r => str(r["Estado"]) == "Pendiente" && num(r["Total"]) > 1000000).ToList().

Related activities

• Sort DataTable — sort the filtered result.
• Aggregate Column — add/count over filtered rows.
• Group By — summarize by categories.