Data360 DQ+

Welcome to the Data360 DQ+ community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  Conditional Filtering

    Posted 12-06-2022 10:45
    There doesn't seem to be a native "IF" "ELSE" type functionality within the tool, in the Filter or Compute nodes an IF function does not exist.
    And even in the SQL or Execute Query in Db nodes the "IF" function is not an accepted SQL function.

    What is the best practice for using a conditional filter?

    ------------------------------
    John Lee
    Healthcare of Ontario Pension Plan (HOOPP)
    Toronto ON
    ------------------------------


  • 2.  RE: Conditional Filtering

    Employee
    Posted 12-07-2022 12:51
    Hi John... Thanks for posting.  Have you reviewed this article?

    IF Else icon | Data360 DQ+ (precisely.com)


    ------------------------------
    Jeffery Brown
    Precisely Software Inc.
    PEARL RIVER NY
    ------------------------------