Custom computed column functions¶

If your organization has developed and installed custom functions, you can add new columns by applying a custom function to existing columns in your dataset. In the following section, you'll learn how to use the Compute tool with a custom function.

Use a custom function¶

To use custom functions with the Compute tool:

1. In Data Prep, click compute in the Tools bar.

2. In the Compute values pane, name the new column.

3. In the formula row beneath the column name, type the name of a custom function. The usage details for the function display beneath the formula row.

4. Select the columns to be used as variables in the function. Follow the usage guidelines to form your expression.

   

   In this example, the custom function is named add_cf, and num1 and num2 are columns in the dataset:

   add_cf(@num1@,@num2@)
   

   If the formula contains errors, the Compute tool displays an error message as it does for built-in functions. The errors also display in the Compute step in the Steps tool until the errors are resolved.

5. Verify that the function is operating as intended by viewing the new column.

6. Click Save to save the new column.