Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Multiple Field formula

Ragini1
8 - Asteroid

Hello Everyone,

 

I am trying to find out a solution to check value in multiple fields and if it has any value it will return Yes. I am using Multiple Field formula for that but am getting output as for all the fields which has transaction. Rather than that I want output as if any of the fields has transaction, it will return Yes. Is there any way.

Appreciate your help.

Thanks!!!

2 REPLIES 2
OllieClarke
15 - Aurora
15 - Aurora

If you have a limited number of columns, then you could use a normal formula such as:

 

IF CONTAINS([Field1],'transaction')
OR CONTAINS([Field2],'transaction')
OR CONTAINS([Field3],'transaction')
OR CONTAINS([Field4],'transaction')
THEN TRUE
ELSE FALSE
ENDIF

It could turn into an unwieldy formula though, so you could transpose your data and check that way too 

OllieClarke
15 - Aurora
15 - Aurora

Here's another way of doing it @Ragini1:

OllieClarke_0-1594397675539.png

 

Labels