Hi,
I try to find within my dataset ( multiple fields) all negative values and tag them as [Field1] + "-E", basically using a conditional if where a value is still positive to tag it as [Field1] + "-E".
I does not work with what I am trying in multi field tool
IF [_CurrentField_]<0
THEN [_CurrentField_] && "-A"
ELSE [_CurrentField_] && "-E"
ENDIF
* incoming data is fixed decimal type
Many thanks!
M.
Solved! Go to Solution.
@Tmanuela
I assume the issue is that your original field is of Double, and by your tagging, it will change to string, so you need to change the data type of your field., and also use the t
@Tmanuela
A quick sample
@binuacs
Nice and quick👍
@Tmanuela
The only difference is that I did not check the Copy To New Column option?
Any ways, this is for the 2nd request.
Glad to help
User | Count |
---|---|
35 | |
27 | |
7 | |
7 | |
7 |