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
Solved! Go to Solution.
Hi @smfhsan2005 ,
Example attached.
Take a look and let me know if this works for you.
Best,
Fernando Vizcaino
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
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.
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