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.
In-Database enables blending and analysis against large sets of data without moving the data out of a database and can provide significant performance improvements over traditional analysis methods. For more about the In-Database tool category, see In-Database Overview.
While most In-DB tools do not require SQL commands, this tool requires SQL for more advanced processing.
Configure the tool
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
- When checked, a query is sent to the database and any errors are reported in the Message display for the tool.
- When unchecked, the query is not sent until the In-Database workflow is complete and any errors are reported in the Message display in any downstream tools