Filter

Keep only the items matching a condition.

TransformFilterItems

What it does

Keep only the items matching a condition.

Parameters

ParameterTypeRequiredDefaultDescription
Items (list / DataTable)variable
Required
Example: items
Field (for list of objects)string
OptionalObject key/column; blank for scalar lists.
Supports variables
Conditiondropdown
is equal to · is not equal to · is greater than · is less than · is greater than or equal to · is less than or equal to · contains · does not contain · is empty · is not empty
Requiredis equal to
Valuestring
Optional
Supports variables
Store result invariable
Required
Example: result

More Transform commands

Ready to automate your busywork?

Start your free 10-day trial today. No credit card, no commitment.