Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Filter Multiple Items at once

matthewprieto
6 - Meteoroid

Hello,

 

I am trying to filter on journal category name first and filter on ces interface then I would like to then filter on the batch name and filter out unbilled or reverses. This is my input below. It is not getting me the correct result. 

 

[Journal Category Name] = "CES Interface"

AND Contains([Batch Name],"Unbilled") OR Contains([Batch Name],"Reverses")

5 REPLIES 5
gabrielvilella
10 - Fireball

Hi @matthewprieto, would you be able to provide a sample dataset? 

matthewprieto
6 - Meteoroid

These are the two columns I want to be filtered. I want it to filter out the first then move on to the next

 

Journal Category Name                       

CES Interface

Accrual

 

Batch Name

Reverses "CES Interface USD"23-OCT-21 00:54:54 - 96527864

Reverses "CES Interface USD"23-OCT-21 00:54:54 - 96527864

Qiu
18 - Pollux

@matthewprieto 
The data is in two streams? or one whole file?

matthewprieto
6 - Meteoroid

one file

ArtApa
Alteryx
Alteryx

Hi @matthewprieto - There are two ways to achieve your desired output:

 

1) Simply apply to filters.

2) Fix the logic in your conditional statement:

([Journal Category Name] = "CES Interface" AND Contains([Batch Name],"Unbilled"))
or
([Journal Category Name] = "CES Interface" and Contains([Batch Name],"Reverses"))

 

ArtApa_0-1642299853932.png

 

Both options are valid. I like more #1 as it is easier to understand.

Labels