I wrote a simple if statement:
IF [Party Office] = "GULFESTMED" THEN [Party Office] = "Gulf East Med" ELSE [Party Office] ENDIF
Instead of text it inserts value 0 to the attribute. Input format of the field is V_String.
Should I set up a different format ?
Solved! Go to Solution.
Hey @mszpot89,
That all looks correct, can you take a screen shot of the workflow and output? Or attach your workflow?
Can you share the an example of the incorrect output and the formula tool setup as well?
Since you are already selecting the field on which you are using the formula, you don't need to add it in the then section.
Try the below:
IF [Party Office] = "GULFESTMED" THEN "Gulf East Med" ELSE [Party Office] ENDIF
Good spot @rahul1011
So funny thing here, after removing the attribute name in THEN part it actually worked.
Input:
Output (before formula change):
Output (changed formula):
Yes @rahul1011, great thanks!
@LordNeilLord - thanks as well!