Function Assist Editor

The item is designed to help users edit function expressions. The visualized Function assist editor allows users to select the desired function, and configure its parameters, options and other information.  as shown below:

Select a cell: The selected cell will be used as the function prefix.

Select a function: Select the desired function. Here functions available will be automatically listed according to return value type of the cell selected in “Select a cell”.

Property settings: In this area you can configure the selected function’s parameters and options. The Property auto-adjusts according to the currently-selected function’s name; you can edit the parameter expression when the Value cell displays an edit box, and select an item when it contains a drop-down list. You can also define the desired property value under property expression Exp.

Click the URL in the lower part of the interface to jump to the current function webpage.

The functions now supported by Function Assist Editor mainly perform these operations – perform grouping, sorting or join on data retrieved from databases or files, and output the result data.

Detailed uses are explained in SPL Visual Scripting.