Skip to main content
Question

Pivoting a table with new field names based on attribute values

  • September 19, 2019
  • 2 replies
  • 21 views

Forum|alt.badge.img+1

Hello all,

Can anyone help me in transforming my feature schema as per the included screenshot? I need to create new field names based on distinct data values held within the existing ‘Attr_Type’ field, and then populate these new fields with the relevant ‘Attr_Value’ value.

I’m using FME Desktop v2019.0.2

TIA,

RB

2 replies

danilo_fme
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • September 21, 2019

Hi @robinb

I tested here in my computer your support.

For the solve this, I used just a transformer AttributeManager.

Inside this transformer I configurated like bellow:

As you can check the Workspace template ( attached ), I search for the values from attributees A,B,C - and set the attribute value = Attr_Value.

 

The result:

 

Thanks in Advance Workspace_Xls.fmwt

 

Danilo


Forum|alt.badge.img+1
  • Author
  • September 23, 2019
danilo_fme wrote:

Hi @robinb

I tested here in my computer your support.

For the solve this, I used just a transformer AttributeManager.

Inside this transformer I configurated like bellow:

As you can check the Workspace template ( attached ), I search for the values from attributees A,B,C - and set the attribute value = Attr_Value.

 

The result:

 

Thanks in Advance Workspace_Xls.fmwt

 

Danilo

Thanks @danilo_fme - that has got me forward to the next step.


Reply


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