Data360 Analyze

 View Only
  • 1.  Conditional Data Entry Custom Node

    Employee
    Posted 05-29-2018 06:58

    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.

     

     



  • 2.  RE: Conditional Data Entry Custom Node

    Employee
    Posted 06-04-2018 08:41

    The data flow has been updated to remove an extraneous field on the node's outputs.

    Attached files

    Conditional Data Entry Node--share - 4 Jun 2018.lna



  • 3.  RE: Conditional Data Entry Custom Node

    Employee
    Posted 02-22-2019 07:33

    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:

    https://d3sa-preview.infogixsaas.com/docs/dist/help/Default.htm#e-node-help/Aggregation_and_Transformation/calculate-fields.html 

    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