Data360 Analyze

 View Only
  • 1.  Compare against multiple values

    Posted 10-14-2021 05:48

    Dear madam, sir,

    Product enhancement request:
    In (at least) the Filter- and Split-nodes, please make it possible to compare the content of a field against MULTIPLE hardcode values, which works as an OR. For example: 'product_code' Equals {code01,code04,code99}

    Thanks in advance!
    Best regards, Bart.



  • 2.  RE: Compare against multiple values

    Employee
    Posted 10-14-2021 09:18

    Hi Bart,

    There is an existing enhancement request for this functionality.

    Ref. LAE-10848



  • 3.  RE: Compare against multiple values

    Employee
    Posted 10-20-2021 01:45

    Hi Bart,

    the above Jira reference is for the other enhancement request you raised - appologies for any confusion caused.

    The existing functionality of the Filter node and Split node enables you to define multiple filter criteria, e.g.

    Selecting a field in the 'Select field' drop-down list will create a new criterion. By default the criteria are joined using the 'Match all of the following' operator - which provides a logical AND of the criteria. You can click on the 'Match all of the following' button to display the other methods for joining the criteria:

    The 'Match any' operator provides a logical OR of the critera and the 'Match none' operator implements the inverse of this, i.e. NOT( <criteria A> OR <criteria B>).

    A single critera group is present on the node by default but you can click on the 'Add new criteria group' button to insert another criteria group into the grid:

    The default operation to join the criteria in each group is to 'Satisfy all groups' i.e. an AND function. You can click on the 'Satisfy all groups' button to change this to 'Satisfy any group' i.e. an OR function.

    For example in the following configuration, the two criteria in the top filter group are ANDed together. Similarly, the two criteria in the lower filter group are ANDed together. The filter groups combined using an OR operator.

    The Split node also supports the equivalent functionality. Please see the node Help documentation for details. 

    If required you can customize the filter criteria with your own scripting by selecting the 'Advanced' tab.

    As noted in the UI, if you modify the criteri script that was automatically generated by the grid selections this will clear the grid. We recommended that when investigating a custom script, you make a copy of the node and modify the script in that node until you are happy with it's operation - this means you still have access to the original filter as a fall-back. 

    Regards,

    Adrian