Data360 DQ+

 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

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

    IF Else icon | Data360 DQ+ (

    Jeffery Brown
    Precisely Software Inc.