I tried to add a formula tool with expression below.
iif(length([GCLID])>50 and ([Score])>3,"Y","N")
What i trying to do is find field "Gclid" string length >50 and field "score" number >3 to mark with Y in the new output field and other with N in the new output field. But it doesn't work. Please help. Thank you!
If there are trailing spaces on the text, you might want to use the TRIM() function. @kevinbird15 is right in that your new variable needs to be a string to accommodate the Y/N values. You could also make it Boolean and use 1&0 values.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return. Please Subscribe to my youTube channel.