1. Home
  2. Guides
  3. Concepts
  4. Tools
  5. References
    1. Apache Spark
    2. Built-in Functions
    3. Incorta Component SDK
    4. Incorta Connector SDK
    5. Connectors
    6. Copilot
    7. Data Studio
      1. Enabling the Data Studio
      2. Aggregation Recipe
      3. Change Type Recipe
      4. Data Quality Recipe
      5. Filter Recipe
      6. Formula Recipe
      7. Fuzzy Join Recipe
      8. Join Recipe
      9. LLM Recipe
      10. Python Recipe
      11. Rename Recipe
      12. Sample Recipe
      13. Save MV Recipee
      14. Select Recipe
      15. Sort Recipe
      16. Split Recipe
      17. SQL Recipe
      18. Union Recipe
      19. Unpivot Recipe
    8. Public API
    9. Security
    10. SQL Interface
    11. Visualizations
    12. Other
  6. Integrations
  7. Data applications
  8. Release Notes
  9. Incorta Premium

References → Formula Recipe

The Formula recipe offers a flexible approach to data manipulation. Any formulas crafted within the feature will be appended as a column on the far right side of the existing dataset, giving you the power to engineer data as you see fit.

Configuration

ConfigurationDescription
Recipe NameA freeform name of how a user would like to name a recipe
InputSelect a previously constructed recipe to process
Add Column(s)
  • Enter the name of the new column
  • The output data type
  • The spark expression to be evaluated.
Or, use Incorta Nexus to generate an intelligent column suggestion:
  ●   Enter the description or desired outcome of your new column.
  ●   Select the Incorta Nexus icon next to the description field.
  ●   View the generated Column Name, Type, and Expression based on your input in the description field.
New ColumnSelect a button to add another formula column. New columns can reference the output value from the columns above it.