Skip to main content
Question

crosstab/pivot transforming for database


I have a table with the following:

Identifikation AuftragsNr FeldValue a1 20160770 450 a2 20160770 EUR/m² a3 20160770 Kita a4 20160770 25.11.2016 b1 20160770 250 b2 20160770 EUR/m² b3 20160770 Kirche b4 20160770 25.11.2016 c1 20160770 350 c2 20160770 EUR/m² c3 20160770 Keller c4 20160770 29.11.2016

I am trying to create a new table with the following:

AuftragsNr

a1 a2 a3 a4 b1 b2 b3 b4 c1 c2 c3 c4 20160770 450 EUR/m² Kita 42699 250 EUR/m² Kirche 42699 350 EUR/m² Keller 42703

I am currently using FME Esri Edition Desktop 2015.1.2.1

I hope that someone can help me.

Thanks in advance!

Mat

2 replies

takashi
Influencer
  • December 15, 2016

Hi @schlauma, a possible way is:

  1. BulkAttributeRenamer: Rename 'FeldValue' with the value of 'Identifikation' (a1, a2, ...)
  2. Aggregator: Aggregate the features grouping by the 'AuftragsNr'.
  3. AttributeExposer: Expose the new attribute names (a1, a2, ...).
  4. AttributeRemover: Remove 'Identifikation' and 'FeldValue', if necessary.

The workflow and the BulkAttributeRenamer parameters setting look like this.


  • Author
  • December 15, 2016

Thank you takashi,

it works perfect.

greetings from Germany

regards Mat


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