+2Hello 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
+32Do you have an attribute that defines what feature each row belongs to?
+2The 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 |
+25If 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
+2Thank you,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
