Hi there,
I'm stuck with something which is seemingly simple yet I cannot for the life of me figure out how to get there.
My data looks like this:
COLORABCRED1007658GREEN254678BLUE335912YELLOW895322I need to find the largest value across A, B, and C. In other words, the output (MAX field) needs to be like this:
COLORABCMAXRED1007658100GREEN25467878BLUE33591259YELLOW89532289I tried the AttributeCreator @max(@Value(A),@Value(B),@Value(C)) function as explained in this thread: https://knowledge.safe.com/questions/50116/max-value-of-two-attribute-of-a-feature.html
But my output "MAX" field still contains plenty of numbers which are certainly not the biggest of the lot, so I'm clearly doing something wrong.
I also tried the StatisticsCalculator, but when I select multiple attributes to analyse, it generates a "max" field for each attribute independently (ie. A_max, B_max, etc.) instead of giving me a general "max" as I desire.
Thanks in advance for any insight,