Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

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

Find a Particular number in a Row

smfhsan2005
8 - Asteroid

Hello Alteryx Comunity, I need help in finding the number 530 in each row and return result as correct else not correct. attached is the sample data. Please help.

 

Thanks

4 REPLIES 4
fmvizcaino
17 - Castor
17 - Castor

Hi @smfhsan2005 ,

 

Example attached. 

Take a look and let me know if this works for you.

 

Best,

Fernando Vizcaino

bpatel
Alteryx Alumni (Retired)

hi @smfhsan2005 

 

if that field is a string data type this formula should work

 

if contains([MNC2[]], "530") then "correct" else "not correct" endif

 

if it is read in as a number this should work 

 

if [MNC2[]]=530 then "correct" else "not correct" endif

 

hope this helps

 

smfhsan2005
8 - Asteroid

Thanks...sorry I didnt specify the column names.... but I want to look in each field, MNC1, MNC1, MNC2 MNC3, MNC4, MNC5 not just MNC 2.

fmvizcaino
17 - Castor
17 - Castor

@smfhsan2005 ,

 

Example attached. I've created 2 solutions, one where I create one column per test and another that tests all columns and generate one single column.

 

Best,

Fernando Vizcaino

Labels