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

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels