Filters

Once we have the data joined, we will apply the filters to categorize the clients. We will create three filters.

Clients with LegalCase = 1 OR PoliceReport = 1 will be classified as red risk category.

Clients with ContactAudit = 1 OR FraudSuspicion = 1 will be classified as yellow risk category.

Only clients with a Credit_amount ≤ 4000 will pass into the green risk category.

This is an example of the first filter:

We will link the output of each filter to a print Output named after its corresponding color.

Now we will connect all three colors to the data that does not pass the filter:

We achieve this by clicking on the connection arrow and selecting "discarded data," which represents the data that did not pass the filter. These records are then passed to the next filter.

In debug mode, we can see that each filter box with discarded rows has two outputs:

This is the workflow so far: