I have the following situation.
One field that can have three distinct values and I need sum two values as a unique value and the other must have the its own value. Sample:
F, J, Y
Value1= sum(F+J) and Value2= sum(Y)
Any idea how I can do this ?
Here you go... i tried the below command, the field newval will be 25
| eval Teste="10,15,60" | makemv delim="," Teste | eval val1=mvindex(Teste,0) | eval val2=mvindex(Teste,1) | eval newval=val1+val2
you can make changes as per your index..
Note: to get the last value (60 in the above example) you can use mvindex(Teste, -1)
let me know if you need any help