Utilize Scripting to define properties.
In a workflow, you can define properties in two places: Workflow Settings or inside nodes.
Global Properties can be read in any other iteration globally for the current execution. You can define them in the Workflow Settings dialog under the properties tab or in a specific node under properties tab.
You can simply define a property with a constant:
return 50; // now the property has a constant value of 50or with a series of calculations:
var date = LocalDate.now();
return date; // now this property has the value of the current date.Note: Global Properties are re-evaluated in each iteration and can have different values.
There are two categories of global properties: those in black, which are user-editable and deletable, and those in gray, which are system-defined properties that have predefined values set during the execution.
You can also define properties inside specific nodes under the properties tab inside each node.
Local properties are only accessible inside the specific node and every following node in the current iteration.
Example: Using the tabular data from the previous node to define a property.
Lets name this property USD:
The previous node sent data about exchange rates in tabular form. We then used NodeInputReader to retrieve the table and access a specific field, in this case the current exchange rate for USD.
Now we have access to a global property USD which contains the exchange rate for the US Dollar.
It is now accessible inside the node and every node that is following this node in the current iteration.
Last updated
// retreive tabular data from previous node.
var table = NodeInputReader.inputAsDataFrame();
// Get the values of the 6th column from the first row (Index 0)
var maxValue = table.column(1).get(0);
return maxValue;