This release brings a major quality-of-life upgrade for pipeline design with the new Condition gem, expanded connectivity with PostgreSQL, and four new analytics gems in prophecy_basics.
Implement pipeline branching logic with the Condition Gem
If you’ve ever chained together multiple filter nodes to handle branching logic, you know how fast pipelines get hard to read. The new Condition gem replaces that pattern with a single, unified component for if / else-if / else logic.
Each condition is evaluated in order, and rows flow through exactly one matching branch. The result is pipelines that are easier to audit, easier to hand off, and much closer to how you actually think about the logic.
The Condition gem compiles into efficient underlying logic, so this higher-level abstraction comes with no performance overhead.
Great for:
-
Routing based on business rules, e.g. customer segmentation, SLA tiers
-
Handling data quality paths, e.g. valid vs. quarantine flows
-
Implementing rule-based transformations without duplicating code
-
Structuring complex pipelines into clear, decision-driven stages
-
Exception handling, separate error paths cleanly
PostgreSQL source and target support
PostgreSQL is now a data source and target in Prophecy. Use the new PostgreSQL Source and Target gems to read from and write to Postgres databases directly in your pipelines — no workarounds needed. See the docs
Simplify your data prep and analysis with new gems
Upgrade to prophecy_basics v1.0.11 or higher to unlock these gems:
-
WeightedAverage: Calculate weighted averages for numeric fields, with optional grouping.
-
RunningTotal: Compute running totals with configurable partitioning and ordering.
-
Tile: Assign records to tiles using methods such as equal sum, equal count, standard deviation bands, or custom cutoffs.
-
Imputation: Replace specified values (such as nulls) in numeric fields with a defined replacement value.
If you’re switching from Alteryx to Prophecy, you’ll be excited to see the familiar functionality of Weighted Average, Running Total, and Tile gems. And the Imputation gem will speed up your data cleaning to get to the real insights faster.
Questions or feedback on this release? Drop them in the comments below.
