I have an interesting problem I am not able to fathom out how to do it. To give some background first, the full table is likely to be about 20 columns and 200000 rows. The data input could change such that the number of rows may change but the column structure stays unchanged.
So the problem is, I have many IDs which are assessed by various categories A, B, C etc and scored against these categories from 0 to 1. I then want to report back the lowest score observed, and which category(s) gave the lowest score. Now I know how to report back the lowest score observed using column aggregator node on Cols A-Z and chose Minimum as aggregation method, but am unsure how to get another column reporting back the column name(s) which gave the lowest score in an efficient way. So an example is:
ID. ColA. ColB. ColC. ColD. ColE
1. 0.1. 0.5. 0.7. 0.2. 0.3
2. 0.9. 0.8. 0.4. 0.4. 0.5
3. 0.6. 0.5. 0.3. 0.8. 1.0
should return these extra columns
ID. MinScore. MinCategory
1. 0.1. A
2. 0.4. C, D
3. 0.3. C.