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
解決済! 解決策の投稿を見る。
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