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
Page 1 / 1
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.
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.
here is w bench
Thanks for the assistance guys. All the methods worked!