Hello Community,
I have data in the following format:
| Attribute | value |
|---|---|
| field1 | a |
| field2 | b |
| field3 | c |
| field1 | e |
| field2 | f |
| field3 | g |
| field1 | j |
| field2 | k |
| field3 | l |
Which transformer can I use to transpose my data into this format?
| field1 | field2 | field3 |
|---|
| a | b | c |
| e | f | g |
| j | k | l |
The names field1, field2, and field3 can be dynamic, and their number may also vary
Do you have an attribute that defines what feature each row belongs to?
The data follows a repeating pattern where every three (or N) rows correspond to one record. However, there is no explicit attribute that groups them. But I can generate a column like objectid
| Attribute | value |
|---|---|
| objectid | 1 |
| field1 | a |
| field2 | b |
| field3 | c |
| objectid | 2 |
| field1 | e |
| field2 | f |
| field3 | g |
| objectid | 3 |
| field1 | j |
| field2 | k |
| field3 | l |
If you have an objectid to define the rows, and you know the fieldnames a flow like this should work:
I’ve attached a workspace based on your example, hope this helps
Thank you,