Conditional Data Entry Custom Node
When preparing data you may need to create a new field whose value depends on whether or not the value in another data field matches a defined condition - for example to implement logic like:
If 'Order_value' is greater than 1000.00 then set 'Free_Shipping' to True else set 'Free_Shipping' to False
Here is a custom node that provides conditional data entry functionality. The node will append a new field to the data and set the value to one of two specified values. You can define the data type of the new field. The node can be configured to output all of the modified records as a single data set on the first output pin, or output the records that match the specified condition to the first output pin and records that do not match the condition to the second output pin.
The node is a standard Composite node but you can convert it to a library node if required (select the node and click the 'Convert to library node ...' option of the hamburger menu on the Dataverse main toolbar).
Note: You will need a minimum of Dataverse 3.2.0 to import the data flow.
-
You can now leverage the Calculate Fields to create fields whose values are based on simple expressions.
For further details see the node Help or online here for the latest version of the documentation:
The following articles also provide an overview of the node's capabilities:
https://support.infogix.com/hc/en-us/articles/360018962714-Data3Sixty-Analyze-3-2-5-is-Now-Available
https://support.infogix.com/hc/en-us/articles/360019122553-Data3Sixty-Analyze-3-2-6-is-Now-Available
https://support.infogix.com/hc/en-us/articles/360018962734-Data3Sixty-Analyze-3-2-7-is-Now-Available
Please sign in to leave a comment.
Comments
2 comments