Skip to content
Nappai Documentation

Filter Data Values

Filter Data Values checks a list of records and splits them by the value of one of their fields. Records that meet the condition leave through one output and the rest through another. This lets you handle each group differently without writing code.

When to use it

  • Separate orders with status paid from those still pending.
  • Keep the customers whose country is Spain to send them a local campaign.
  • Spot products whose stock is below a minimum.
  • Find records with an empty field, such as customers with no phone number.

Configuration

FieldWhat it does
Input DataThe list of records you want to filter.
Filter Key (required)The field to compare, for example status.
Comparison Operator (required)How the field is compared with the value. Default: equals. Options: equals, not equals, contains, starts with, ends with, is empty, is not empty, grater than (greater than) and less than.
Filter ValueThe value to compare with, for example paid. Required except with is empty and is not empty. Upper and lower case matter.

Advanced options

FieldWhat it does
Regex FilterA text search pattern. If you fill it in, it is used instead of Comparison Operator and Filter Value: records whose field matches the pattern pass.

In the Batch Mode tab, the Skip Branch if Empty Output option (on by default) stops the steps connected to an output that ends up empty from running. Turn it off if you want those steps to run anyway. More about this mode in Batch Mode.

Output

  • Filtered Data: the records that meet the condition.
  • Rest of Data: the records that do not.

Records that do not have the Filter Key field leave through neither output. grater than and less than only work with numeric values.

Example

A shop wants to remind customers whose orders are still unpaid.

  1. Connect the order list to Input Data.
  2. In Filter Key, type status; in Comparison Operator, keep equals; in Filter Value, type pending.
  3. Connect Filtered Data to the component that sends the reminder. If you like, connect Rest of Data to another step, for example to prepare shipping for the paid orders.