Find a Particular number in a Row

[smfhsan2005]

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

[fmvizcaino]

Hi @smfhsan2005 ,

Example attached. 

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

Best,

Fernando Vizcaino

[bpatel]

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]

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 · Accepted solution]

@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