Add multiple filters to one filter

Hello - I know there have been multiple posts regarding this question but I am not having any luck. I am trying to do all these filters in one job. The one filter that is blank is CRM FRISK is null. Everything I'm trying is not working. any direction would be much appreciated.

Developer

Tips and Tricks

Custom Tools

Accepted answers

jrgo

Set it up more like this

Without the Union and place the Block until done after the FALSE output of the filter. This should ensure that the first output is complete before the second output tool starts. If you're still getting errors regarding the file is open, you'll have to go a different route, but we'll cross that bridge if this option doesn't work.

All comments

jrgo

@dberroth

I could be mistaken on what exactly it is you're asking for help on, but if the question is if you can consolidate the expression used in each filter into one, the expression below could be used

![Total AR Balance]
AND [%] >= 40
AND [FSS] <= 20
AND ISNULL([CRM FRISK])
AND NOT [Risk Category] IN("MISFRT","YARD","FLIP","CARREP")

For the last 4 Filters, I use a NOT operator with the IN clause.

If I did misunderstand the question, can you clarify?

Jimmy
Teknion Data Solutions

DiganP

@dberroth Would you be able to attach a sample dataset? It would help us understand the workflow better.

dberroth

@jrgo you have the right idea of what I'm trying to do. I'm basically trying to clean up this flow so it looks more presentable and clean. The statement you gave me makes sense, but now I'm not getting any data. All records are coming out as false. Any ideas? Your formula makes sense to me.

dberroth

The formula I'm using now is below. I only need the total AR balance greater than 50000. I took what was given earlier in this post and added the >50000. Doesn't make sense to me why this wouldn't work and only come back with falses after these same filters shown in my original post works.

![Total AR Balance] > 50000
AND [%] >= 40
AND [FSS] <= 20
AND ISNULL([CRM FRISK])
AND NOT [Risk Category] IN("MISFRT","YARD","FLIP","CARREP")

dberroth

do you have any links to any documentation where I can learn this type of syntax?

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335