filter-rows
Action
Filter rows based on a condition with comparison operators
Syntax
$result:NUMBER = filter-rows $Gtable where "status" equals "active"
filter rows with literal column and value using equals
$result:NUMBER = filter-rows $Gtable where "age" gt 18
filter rows with literal column and numeric value using gt
$result:NUMBER = filter-rows $Gtable where $column:TEXT equals $Avalue
filter rows with variable column and value using equals