Using derived property values is a very powerful technique in Data360 Analyze, which allows you to substitute the values of properties from one (typically centralized) location to another, for consistent reuse of common values across your data flows. For example, paths for input/output data, or parametrized aspects of your analysis, such as locations or dimensions upon which to perform complex analyses.
You can explicitly substitute a property value into another property by typing the following text, where propertyname
is replaced by the name of the property:
{{^propertyname^}}
Alternatively, you can select a property to reference from the node property menu:
- Click the menu button on the node property where you want to insert the reference.
- Select Property References then choose a property group. Choose from:
- Data Flow Properties – Properties on the top-level data flow.
- Run Properties – Run properties defined on the top-level data flow.
- Container Properties – Properties on the container node of the reference.
- Local Properties – Properties on the same node as the reference.
- Select the specific property that you want to reference.
The chosen property reference is inserted at the cursor position in the related field.
A property reference can be combined with further text to build larger values:
{{^rootpath^}}\{{^datafolder^}}\input.csv
Substitute within script
Input data:
model:unicode |
---|
roadster |
Y |
The input data is passed to a Transform node which has a property called make
with the following value:
Tesla
The Transform node is configured as follows:
ConfigureFields
out1 += in1
out1.make = unicode
ProcessRecords
out1 += in1
out1.make = in1.model + ' ' + '{{^make^}}'
In this example, the Transform node concatenates the value from the input with the value from the make
property on the Transform node.
Note that in this example the property reference must be surrounded in quote marks to indicate that the value is a string, and produce the following output:
model:unicode | make:unicode |
---|---|
roadster | roadster Tesla |
Y | Y Tesla |