Question

Pivoting a table with new field names based on attribute values

  • 19 September 2019
  • 2 replies
  • 0 views
R
Badge

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
Rank
Userlevel 4
Badge +30

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

R
Badge

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


Community Stats

28,707
Posts
109,477
Replies
36,551
Members
Terms & ConditionsCookie 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.