Generate custom steps for your exact needs

The Custom transform step lets you describe the logic you want to run on your data, and automatically generates a custom step using AI. This improvement will eliminate complex building patterns, enable faster Flow building, and unlock totally new data transformation and analysis capabilities. 

How to use the step 

The Custom transform step works best for logic-based tasks—calculations, formatting, and structured transformations—similar to what you’d normally do with Excel formulas or Parabola’s other Transform steps.

Your input

• A table of data
• Data transformation instructions—exactly how you'd explain it to a teammate
  • Example prompt: "Calculate total revenue for men's products by SKU per month. Return the following columns: Month, SKU, Product Title, and Revenue. Format revenue as currency ($100.00)." 

Parabola's output

• An updated dataset, transformed based on your instructions
• Documentation outlining the logic in your AI-generated code

‍

Locking your instructions

• Once you’re happy with the results of the step, you can select "Keep the logic" to ensure consistent results. More in the FAQs below. 

Try it now with sample data

Video overview

Example use cases 

The list of ways that you can use this step are truly endless. Here are some examples for inspiration: 

• Perform calculations across rows of data, like percent of total and weighted average calculations
• Perform date math, like adding a number of days or weeks to a date value to calculate SLA performance
• Perform complex statistical calculations, like finding the first and third quartile
• Create pivot tables or add subtotal and total rows, like a dynamic sales report where you can see both sales totals and averages by metric
• Dynamically convert column names based on patterns, like assigning week numbers to columns for upcoming periods in your demand planning table
• Duplicate rows based on conditional logic, like duplicating order line items with where the quantity is greater than one for your 3PL
• Add rows to fill in the values between two numbers or dates, like filling in all values between two zip codes
• Extract text using custom logic, like extracting values from the middle of a consistently-formatted list
• Generate unique IDs, like SKUs for all new parts received from a vendor
• [Beta] Create JSON schemas and HTML tables, like API request bodies and nicely-designed tables to insert in email bodies

In short: If you can describe it in code or Excel, you can probably build it with this step.

Build your own use case using a custom transform

Templates

Want to see the step in action? Explore these Templates from our use case library that leverage this step:

• Carrier scorecard: In this Template, we use the Custom transform step to calculate scorecard metrics such as damage-free rate, total shipments by carrier, and on-time performance. We also use the step to generate an HTML-formatted table, which we then include in a Send email by rows step.
• Inventory reconciliation: To identify discrepancies in this Flow, we use a Custom transform step to remove retired products, calculate discrepancies across our ERP, WMS, and Shopify, and then output a "SKU Status" column indicating where discrepancies exist.
• Freight & parcel invoice audit: To identify billing overages, in this Template we use a Custom transform step to calculate discrepancies between our quoted rate and amount invoiced—calculating both the actual amount and a percentage. From there, we format our results accordingly.

Best practices

As with any tool that leverages LLMs, the more specific your instructions are, the better your results will be. Here are some prompting tips: 

• Be as specific as possible regarding your target output. Specify whether columns or rows should be added, removed, or modified. If you’re adding new columns, specify how you want the column(s) to be named. 
• In your instructions, reference exact column names from your input table.
• Use examples to clarify complex logic.

Beyond prompting, here are some additional best practices: 

• Break large processes into multiple Custom transform steps to maintain Flow readability and improve results. The more you ask the LLM to do in a single prompt, the less accurate the results will be. 
• Enable “Keep this logic” once your results are accurate.
• If you need help fine-tuning your prompt, run it through ChatGPT and ask, “How should I improve these instructions for use in Parabola’s Custom transform step?” 
• If your Flow results on values being very standardized after this step, consider using a Standardize with AI step for post-processing.

Put these into practice in-app

FAQs

• Q: How broad should my prompts be within a single step?
  
  • A: Custom transform step results will be most accurate with focused prompts. Think about one Custom transform step as doing a similar amount of work as any other Parabola Transform step for best results. For more complex tasks, consider using multiple Custom transform steps
• Q: When should I use out-of-the-box Transform steps (like Filter rows) vs. Custom transform?
  • A: If a step already exists for the transformation you’re trying to accomplish, we will always recommend using the pre-built step. Steps like Edit columns and Add math column have been extensively tested by Parabola’s engineering team to ensure they are performative and results are accurate. We recommend you use a Custom transform step when you need a step that doesn’t yet exist.‍
• Q: Can this step accept multiple inputs? 
  • A: At this time, the Custom transform step can only accept a single input. Continue using steps like Combine tables and Stack tables for multi-input transformations. ‍
• Q: What’s the difference between “Regenerate logic each time” and “Keep this logic”? ‍‍
  • A: Regenerate logic each time: When this setting is enabled, the step will re-evaluate your instructions and data every time the step runs before generating the custom code that powers your step. This is like getting a fresh set of eyes on the data and instructions every time, and can be useful if context from your data may change from run-to-run and should be taken into consideration when step logic is being generated. ‍‍
  • A: Keep this logic: When this setting is enabled, we’ll use the same logic summary to generate code every time the Flow runs without re-looking at your instructions or data. This ensures that your step logic stays consistent from run to run. ‍
• Q: When should I use steps like Experiment with AI or Categorize with AI instead of a Custom transform step? 
  • A: The Custom transform step is best for logic-based transformations—especially those involving math or data analysis.For interpreting or generating content, steps like Extract with AI and Categorize with AI will be the most useful. ‍
• Q: Can this step pull information from the web or external services? 
  • A: No; this step cannot search the web today. You can use Parabola’s API steps to pull in external data. ‍
• Q: How is this step priced?
  • A: The Custom transform step is included on all plans at launch at no additional cost. Parabola reserves the right charge for usage of AI-powered steps.
• Q: Are there any step limitations or ‘gotchas?’ 
  • A: There are four main factors to keep in mind when working with this step: 
    
    • This step works best when tabular data is coming in and out, just like our normal Transform steps. While the step does have some HTML- and JSON-generating capabilities, these additional output formats are in beta today. 
    • This step cannot search the web. 
    • This step cannot accept multiple inputs. 
    • Keep in mind that LLM-generated steps can be less predictable than pre-built Parabola steps.

Try it now with sample data