◄Show Table of Contents

Formula In-DB Tool

The Formula In-DB tool creates or updates fields in an In-DB data stream with an expression using the native language of the database, such as SQL. Use the Formula In-DB tool to modify data within a database based on an expression or data relationship.

ClosedThis is an In-Database Tool.
(missing or bad snippet)

While most In-DB tools do not require SQL commands, this tool requires SQL for more advanced processing.

Configure the tool

  • Output Field: This is the field the formula will be applied to. Choose a field listed in the drop down or add a new field.
  • Type: Select the appropriate Data Types of the new field. If an existing field is selected, the Type is for reference only.
  • Expression: The expression box is for reference only. It will populate with the expression built in SQL Expression. The formulas constructed here are embedded within a SELECT statement.
  • Navigation buttons: Click to set the order of formula execution. Click to delete the selected formula.
  • SQL Expression: Build the expression to be applied to the specified field.
    ClosedBuilding an expression

    Use the Insert Fields drop down to pick from available fields to construct your formula. Select a field name to add it to the expression field, or write a custom expression. The expression will be added to the Expression field at the top as it is being written.

    A SELECT command is not required to write a CASE statement in the In-DB Formula tool. You can use the expression: CASE WHEN [FIELDNAME] = 'condition' THEN 'calculation'...END

  • Insert Fields: A list of available columns that can be inserted in the SQL Expression editor.
  • Validate expression here at runtime: Provides information about errors contained in the expression.

    • Alteryx.com | Community | Customer Support | Documentation Feedback

    ©2018 Alteryx, Inc., all rights reserved. Allocate®, Alteryx®, Guzzler®, and Solocast® are registered trademarks of Alteryx, Inc.