Defining AND clause in Business Rule

Highlighted
One Star

Defining AND clause in Business Rule

Hi there,
I was wondering whether it was possible to define AND clauses when defining business rules in Data Quality. For example, I wish to know in a table how many rows are from 'UK' by the country column and of those how many have a invoice greater than £5000.
I tried defining in the business rule like Country = 'UK' and Invoice > 5000 but I don't think this works or gives me the correct answer. Also, I tried setting these two rules separately but I think it just gives me how many rows are UK then it gives me (regardless of country) how many rows have invoice greater than 5000.
How can I use the AND rule?
Thanks,
Facoda
One Star

Re: Defining AND clause in Business Rule

Hi All, 
Ok I think I found a solution to my problem. The answer is to use a filter in the table analysis section and then apply the business rules.
But does anyone know how to write the filter expressions? Are they the same as SQL? For example if I write in the expression in the where filter like: Country = 'UK-England' AND 'UK-Scotland' it doesn't work but if I write: Country IN ('UK-England','UK-Scotland') it works.
Is there a reference Talend on how to write the expressions?
Thanks,
Facoda

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read