CSV Filter Rows
Filters rows in a Table based on a comparison operation on a specified column. Returns a new Table with only matching rows.
Inputs
| Name | Type | Required | Description |
|---|---|---|---|
| table | json | No | - |
| column | string | Yes | Column name to filter by |
| operator | string | Yes | Comparison operator: equals, notEquals, contains, notContains, startsWith, endsWith, greaterThan, lessThan, greaterThanOrEqual, lessThanOrEqual |
| value | string | Yes | Value to compare against |
Outputs
| Name | Type | Description |
|---|---|---|
| table | json | Filtered Table with matching rows |
| matchCount | number | Number of rows that matched the filter |
Related Nodes in Data Processing
JSON Extract String
Extract a string value from a JSON object using JSONPath
JSON Extract Object
Extract a JSON value from a JSON object using JSONPath
JSON Merge
Merge multiple JSON objects
JSON Template
Create a JSON object using a template with variable injection using ${variableName} syntax
JSON Flatten
Flatten nested JSON structure into a flat object with dot notation
CSV Parse
Parse a CSV string into a Table with schema and data
CSV Stringify
Convert a Table with schema and data into a CSV string
CSV Extract Column
Extract all values from a specific column in a Table
Regex Extract
Extract all matches of a regular expression pattern from a string.
Regex Replace
Replace all matches of a regular expression pattern in a string.
Regex Match
Test if a string matches a regular expression pattern.
String Concat
Concatenate multiple strings together
Calculator
Evaluates mathematical expressions with support for arithmetic, functions, and constants.