Example
Name | Try 1 | Try 2 | Try 3 | Try 4|
Tom| 3 | 6 | 0 | 2 |
Bob | 2 | 7 | 1 | 6 |
Kat | 1 | 8 | 1 | 3 |
Export
Name | Try | Highest Score
Tom | Try 2 | 6
Bob | Try 3 | 7
Kat | Try 2 | 8
Much appreciated
Solved
Hi Team, I am fairly new to FME. I am trying to find and export the maximum value across a few attributes. Please see example below.
+2- Contributor
- 4 replies
Best answer by ctredinnick
Learn the example above first, but..
The uglier, less dynamic way to do this is with the @max() function, which takes the largest value of its inputs. And a conditional to identify which attribute it was which matched.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+7- Contributor
- 25 replies
Hi Calvin,
One way you could do this is;
Basically, split each Try 1,2,3,4 into a separate row. Do this by creating a common attribute (i.e. Value) and comma separate the values (AttributeCreator):
Split that column using the AttributeSplitter, splitting based upon Comma. This will create a list, that you will need to explode (using ListExploder)
The new value _list is created. Just use AttributePivoter to group the rows by the Name and analyze the _list attribute and create the summary as Max.
After the Data output from AttributePivoter, you can use the AttributeRemover transformer to clean up any attributes that you don't want to keep.
+19- Supporter
- 225 replies
- Best Answer
Learn the example above first, but..
The uglier, less dynamic way to do this is with the @max() function, which takes the largest value of its inputs. And a conditional to identify which attribute it was which matched.
