Using Functions in the Studio

One of the key features of Graph.Build Studio is the ability to use functions to modify data during the transformation process into graph formats. Details of all the available functions can be found here.

To start working with functions, navigate to the Functions input tab. Functions are grouped by query in the SQL Transformer and by input file in the Semi-Structured File Transformer.

To create a function, press the + New Function button.

In the Function Name field, you can search for the desired function using autocomplete. The Function Label field allows you to assign a label to the function, making it easy to identify the output data when using it in your graph model.

Once the appropriate function is selected, the required parameters for the function will be displayed. Depending on the function, these parameters can be populated either by selecting fields from your source data or by entering data manually.

In the example above, the toUppercase function has been selected, and the field first_name from the source data has been used. The function has been labelled firstname_uppercase. After all required fields have been completed, press the Add Function button to confirm.