Automate

Hi,

I am wondering if it is possible to have an "OR" operator instead of an "AND" operator in the criteria for table-join queries. I am trying to create exception-based reporting, so I only want to see records that DON'T conform to established data quality rules. Simple example below:

In this case, I want to query and pinpoint FERTs where the base unit of measure is not equal to "CS" OR where the product hierarchy is null, because both violate established data quality rules, but are unlikely to coincide with each other.

Thank you,
Orlando

Please feel free to open a support ticket to request an improvement.

For your use case, you'd have to run the query twice - once with each criteria.  You can append the results of both to get to what you want.

Best Regards,
Sigrid

Hi,

I am wondering if it is possible to have an "OR" operator instead of an "AND" operator in the criteria for table-join queries. I am trying to create exception-based reporting, so I only want to see records that DON'T conform to established data quality rules. Simple example below:

In this case, I want to query and pinpoint FERTs where the base unit of measure is not equal to "CS" OR where the product hierarchy is null, because both violate established data quality rules, but are unlikely to coincide with each other.

Thank you,
Orlando