Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Multi Column Formula

btkenney603
5 - Atom

Hello, 

 

I'm having trouble filtering out 2 integers in separate columns with the filter tool. My expression below is what i have come up with. Does anyone know why this would not work?  

 

Thanks

 

 [ACCOUNT]=50550 AND [SUBACCOUNT]=10 

2 REPLIES 2
AngelosPachis
16 - Nebula

Hi @btkenney603 ,

 

If you have no records falling out of the "T" anchor of your filter tool, then that means that there are no records that have simultaneously the values 50550 for ACCOUNT and 10 for SUBACCOUNT.

 

If you want to filter out all records that either have 50550 for ACCOUNT or 10 for SUBACCOUNT, you can amend your expression to 

 

[ACCOUNT]=50550 OR [SUBACCOUNT]=10 

 

 

echuong1
Alteryx Alumni (Retired)

Your expression should work. The only thing I can think of that would cause an issue is if your datatypes are mis-matched. You can use tostring() to convert everything to strings and have the accounts and subaccounts in quotation marks.

 

If you want to have each separate, use an or instead of and. 

 

echuong1_0-1610130905953.png

 

Labels
Top Solution Authors