April 2026 Pipelines Qrew Meetup Recap
Hi Pipelines Qrew!
Thank you all who were able to join the Pipelines Qrew meetup On Wednesday. Wes McAda shared three use cases for using Pipelines and Jinja for Project Expense Summaries. Those three include:
- Using Jinja + namespace to pull unique Project IDs from an expenses table and upsert parent Project records
- Using a callable low-code pipeline to find expenses missing a related summary, create or find the matching Project Type Summary, and relate sibling expense records
- Using Jinja + regex + namespace to calculate scalar dollar values, handle null expense types, and distribute records into separate Food, Lodging, and Unallocated tables
Qrew tips from the meeting:
- Wes McAda’s Qrew tip: Think about data volume, reporting needs, and performance when deciding between relational summaries and scalar values. The best approach really depends on the use case.
- Jim Harrison’s Qrew tip/example: Jim brought up another potential use case to replace “search” with buckets as they can be a very efficient way to pivot and transform data in a pipeline and shared an example to the Qrew to review.
Missed the meeting? Here’s the recording.
Want the YAML? Reach out to me via email [email protected] for copies of it.
As a reminder, we will not be hosting any virtual Qrew groups in May. Instead, we will meet up in Houston on May 18th at 7pm on the 6th floor of the Marriott Marquis for a special Qrew Meetup the day before Empower 2026. Hope to see you there!