Invoke External Function

Through the Search panel, you can access and apply functions that have been developed external to  Designer Cloud Enterprise Edition.

Pre-requisites

Invoke

After an external function has been registered with the product, you can complete the following steps to invoke the function within your recipe. 

Steps:

1. In the Transform Builder, you can search for any of the following:
   1. udf

   2. invoke external function

      NOTE: You cannot search for the name of the external function.

2. Select Invoke external function. 
3. The list of available external functions is displayed. Select the function to use. 
4. Depending on the function, the following options may be available:
   1. Columns: specify the column or columns to which to apply the function. 
   2. Arguments: If the function accepts arguments, you can enter them on individual lines.
   3. New column name: Some functions generate a new column. Enter a new column name.
5. To add the instance of the function to your recipe, click Add.
6. The step is added to your recipe.

Examples

You can create these examples functions in Java for use in the platform. For more information, see Java UDFs.

ConcatUDF

The ConcatUDF function concatenates two strings together. 

AdderUDF

The AdderUDF function adds an input value to a constant that is submitted by parameter. The following invocation of AdderUDF adds colA and the constant 100.