We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Formula Help

codytom
6 - Meteoroid

Hi,

 

I am trying to build a "Check" formula.

 

How would I build this in Alteryx?

 

codytom_0-1607723395255.png

 

2 REPLIES 2
marcusblackhill
12 - Quasar
12 - Quasar

Hey @codytom !

 

Can do the same way, only need to get formula tool and add a new column with that name and the name of the fields of your calculation like this

marcusmontenegro_0-1607723748861.png

Hope that helps!

 

Qiu
21 - Polaris
21 - Polaris

@codytom 
A bit extention to @marcusblackhill  answer, we can use 'string' for the check result.

And if your data column number varies, a dynamic way like below should be considered.

1212-codytom.PNG

Labels
Top Solution Authors