Can anyone help me to figure this out. I am loading the file, and changing one of the fields in the script
However, created field 'Repeat' only shows '0', even if the was 'No' in the original file.
What if you try this:
If(Capitalize(Trim(yourField)) = 'Yes', 1, 0) as Repeat
View solution in original post
maybe there are some spaces or mistypes, please check
Don't use as "Repeat" but as Repeat.
And in addition to Clever, besides checking the fieldname, check Yes/No for the exact same use of capitals.