Custom Script

This node empowers you to incorporate your custom scripts to perform specific data operations on your data - tailored to your unique requirements.

This node accepts input of two types, a file or data.

• You can use ctrl+space for autocomplete

• Type Util to get all function groups, pick one and then type a dot to view all functions within the group. All Util Classes are available to view at Utility Classes.

• You can use NodeInputReader to get the nodes input object.

The following example, filters the input DataFrame by column Country (16), returns a new table with records from the input table where country is "USA".

// Read input data into a DataFrame
var table = NodeInputReader.inputAsDataFrame();

// Extract the first column as a string column
var stringColumn = table.stringColumn(0);

// Filter the DataFrame to include only rows where the values in the first column end with "USD"
var filteredTable = table.where(stringColumn.endsWith("USD"));

// Return the filtered DataFrame
return filteredTable;