Skip to main content
Solved

Key Value Row Groupings

A
Forum|alt.badge.img

I'm having some trouble assembling a record set in the way I want to assemble it.

I currently have features structured like the following

Attribute AAttribute BAttribute CGroupValue1KeyValueGroupValue1Key2ValueGroupValue1Key3ValueGroupValue2KeyValueGroupValue2Key2ValueGroupValue2Key3Value

Where each row is a feature (except the first in this case, which are attribute names).

What I would like is to create a new feature grouping on Attribute A, with Attribute B holding attribute names for this new feature and Attribute C holding the value of those attributes. I've looked into attribute pivoter and aggregator to accomplish this; but I can't seem to figure out how to pull this off. Any ideas on what I'm missing? In my data, I can guarantee the uniqueness of Attribute B across unique values of Attribute A.

Maybe what I'm asking for isn't possible. I'm not sure.

Best answer by aarongundel

I actually answered my own question. In the above example, what I was after as a final result would have produced two features.

GroupValue1 (new feature) with Key1, Key2, and Key3 as attributes on that feature

 

GroupValue2 (new feature) with Key1, Key2, and Key3 as attributes on that feature

The AttributePivoter actually gave me what I needed, but I needed to make an Attribute Manager to define those attributes (Key1, Key2, and Key3) in advance. It appears that it was working correctly, but the attributes appear to be "hidden" on the feature because they were not defined in advance.

View original
Did this help you find an answer to your question?

2 replies

ebygomm
Influencer
Forum|alt.badge.img+39
  • ebygommInfluencer
  • Influencer
  • October 20, 2017

Can you post the structure you're aiming to get to?

A
Forum|alt.badge.img
  • aarongundel
  • Author
  • Best Answer
  • October 20, 2017

I actually answered my own question. In the above example, what I was after as a final result would have produced two features.

GroupValue1 (new feature) with Key1, Key2, and Key3 as attributes on that feature

 

GroupValue2 (new feature) with Key1, Key2, and Key3 as attributes on that feature

The AttributePivoter actually gave me what I needed, but I needed to make an Attribute Manager to define those attributes (Key1, Key2, and Key3) in advance. It appears that it was working correctly, but the attributes appear to be "hidden" on the feature because they were not defined in advance.

Reply


Helpful Members This Week

Community Stats

31,468
Posts
119,283
Replies
39,083
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.