Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

AND Custom Filter

grsomer
8 - Asteroid

Hi!

I want to create a custom filter that does the following: 

1) Filters the coloumn TRADE_KEYWORD.BO_ProductType for Cash_Margin & Fees_BBL_ACCR 

and 

2) Filters the column Maturity Date to exclude "June" & Blanks

 

Is it possible to create a statement that would do this in the custom filter?

Thanks!

2 REPLIES 2
LordNeilLord
15 - Aurora

Hey @grsomer 

 

I'd personally break this down into multiple filters for easier maintenance but if you did want to do it in one it would be something like:

 

TRADE_KEYWORD.BO_ProductType in ("Cash_Margin" ,"Fees_BBL_ACCR") 

AND

([Maturity Date] != "June" AND IsEmpty([Maturity Date]))

danilang
19 - Altair
19 - Altair

hi @grsomer 

 

This should you for you

 

[TRADE_KEYWORD.BO_ProductType] in ("Cash_Margin", "Fees_BBL_ACCR")

and 

[Maturity Date] != "June"

AND 

!isempty([Maturity Date])

 

Dan

Labels
Top Solution Authors