Filter Multiple Items at once

[mprieto200]

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")

[gabrielvilella]

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

[mprieto200]

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]

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

[mprieto200]

one file

[ArtApa]

Hi @mprieto200 - 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"))

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