Solved

multiple rows to one row with dynamic columns

  • 1 September 2021
  • 1 reply
  • 4 views
F

How can i do this? I tried everything i could.

The number of columns needs to be dynamic.. if Town III is 5 times then there should be JB5 ZB5 and RT5.

The RT1 Column is the Order in which they should be (see colour)

col

icon

Best answer by geomancer 2 September 2021, 14:31

View original

1 reply

geomancer
Rank
Userlevel 4
Badge +36

The custom transformer ListBreaker from FME Hub may be what you want. You will have to expose the new attributes. See the attached workspace (FME 2020.0).

ListBreakerSteps:

  1. Rename attributes JB1, ZB1 and RT1 to JB, ZB and RT
  2. Create a list, grouping on attribute JB
  3. Sort the list on attribute RT
  4. Use the ListBreaker to write the list to new attributes, start numbering at 1, no numbering prefix
  5. Expose the attributes. You set the order of the attributes here
  6. Remove the superfluous attributes JB, ZB and RT, and the list

Reply


Community Stats

28,684
Posts
109,412
Replies
36,542
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.