configuring-filters

What problem does it solve?

This Skill helps you prevent bad, irrelevant, or incomplete records from clogging your Celigo AI-driven pipelines by applying precise filter rules at the right execution point.

Core Features & Use Cases

• Record gating across the pipeline: Apply filters to export output, import input, lookup input filtering, and flow router branch routing so only intended records continue.
• Expression-first filtering: Build fast, declarative S-expression rules using operators like equals, contains, empty/notempty, and logical combinators (and/or/not).
• Script fallback for complex logic: Switch to script-based filters when you need multi-step conditions, date math, or custom evaluation that expressions cannot model.
• Practical testing and debugging: Use job stats concepts like numIgnore to validate that filtered records are being skipped (not errored).

Quick Start

Add an expression output filter to your export so only records with a non-empty email continue into the flow.