Skip to main content

Filter Rows

Description​

Filters for rows that match the specified condition.

Parameters​

  • Field to Filter: Filter rows based on the value of this field.
  • Filter Operator: The conditional operator for your filter (eg. ">", "==", etc.).
  • Filter Value: Compare the this value to the field to filter.

Input Requirements​

Input schema may be any format.

Important: Ensure your Filter Value matches the logical type of your data. If there is a mismatch, such as entering a value in Epoch Milliseconds when your data is in Epoch Microseconds, the filtering will not work as intended.

Expected Output​

Outputs the same format as the input, excluding rows that were filtered out.

Example​

Input:

// Field to Filter = "purchase_date"
// Filter Operator = ">="
// Filter Value = "2023-03-15"
purchase_datepurchase_id
"2023-01-25""k4F5oOTB"
"2023-03-15""1HW7ZbkB"
"2023-05-12""qApxU7uD"

Output:

purchase_datepurchase_id
"2023-03-15""1HW7ZbkB"
"2023-05-12""qApxU7uD"