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)
Page 1 / 1
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).
Steps:
- Rename attributes JB1, ZB1 and RT1 to JB, ZB and RT
- Create a list, grouping on attribute JB
- Sort the list on attribute RT
- Use the ListBreaker to write the list to new attributes, start numbering at 1, no numbering prefix
- Expose the attributes. You set the order of the attributes here
- Remove the superfluous attributes JB, ZB and RT, and the list