Skip to main content
  • EN

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

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.

Thank you takashi,

it works perfect.

greetings from Germany

regards Mat

Reply


Community Stats

30,126
Posts
114,364
Replies
37,763
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.