Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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