Skip to main content
Question

Get column name from maximum row value

  • June 17, 2019
  • 2 replies
  • 34 views

dxirgu
Contributor
Forum|alt.badge.img+4

Hello,

 

I'm new at FME and I can't the way to solve this problem. I have a dataset like this:

OONNNEEEESSSSOVALUE123123456431678845221SS445765976455566678763NE

 

I want to get, for each row, the column name where there is maximum value.

 

Thanks.

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.

2 replies

ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3427 replies
  • June 17, 2019

It's possible but not straightforward in FME. I would probably use python to do this, but it can be done with a combination of an attributeexploder, a list sorter and an attributecreator

 

 

Find_attr_with_max_value.fmwt


dxirgu
Contributor
Forum|alt.badge.img+4
  • Author
  • Contributor
  • 18 replies
  • June 21, 2019

It's possible but not straightforward in FME. I would probably use python to do this, but it can be done with a combination of an attributeexploder, a list sorter and an attributecreator

 

 

Find_attr_with_max_value.fmwt

Hi, egomm,

it works! I really apreciate your helpful.

Thanks so much!!