Filter not producing True Results from data

I'm currently working a workflow where I am filtering on an account, and then creating another filter on a product for a true/false result. When I run the workflow, the product filter produces zero True results although there should be data produced from the filter after looking through the inputted files.

Thank you

Alteryx Workflow Question.docx

Workflow

Output

Help

Accepted answers

Thableaus

Hi @nshields001

THe problem here is that you're using the "AND" clause.

In this case you should either use "OR" or the operator "IN" as you did in your Account Filter.

Cheers,

All comments

Thableaus

Hi @nshields001

THe problem here is that you're using the "AND" clause.

In this case you should either use "OR" or the operator "IN" as you did in your Account Filter.

Cheers,

LukeG

Hi @nshields001

It looks like in your filters there is an "AND" operator. The reason nothing results as true is because no values in the product field are all of those values at once.

In other words the product field cannot be "LFI148" AND "LF145", but it can be "LFI148" OR "LF145"

Let me know if that helps or if there are any other questions.

Luke

nshields001

This worked thank you!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335