I derived a new column using if statement as per requirement named "OPS REGION".Now i wanted to make some changes in that column using purge char function but when ever i am loading the script after using this purgechar it giving error that "OPS REGION"
Possible to copy paste the script here to look where exactly the issue?
Or you can make sure you are loading the name of the field properly, as fields are case sensitive . If the field has the underscore, make sure also that it doesn't have to be enclosed in some way.
Make sure you placed a comma next to the field unless it is not a last field in the table.
