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)
Solved
multiple rows to one row with dynamic columns
Best answer by geomancer
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
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+60- Evangelist
- Best Answer
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