Hello,
I am trying to string together attributes. The difficulty is that the attribute names can vary by dataset.
Generally what i am trying to do is that may look something like this:
| DEPTH [m] | Measurement 1 | Measurement 2 | Measurement 3 | Measurement 4 |
|---|---|---|---|---|
| 0.5 | <NULL> | 1 | 4.5 | 2.1 |
| 1 | <NULL> | 2 | 2.3 | 2.2 |
| 1.5 | 3.5 | 1 | 1 | 2.1 |
| 2 | 3.0 | 1 | 4.5 | <NULL> |
What I am trying to accomplish is something like this
| DEPTH Hm] Measurement1 | DEPTH Hm] Measurement2 | DEPTH Hm] Measurement3 | DEPTH Hm] Measurement4 |
|---|---|---|---|
| <NULL> | 0.5 1 | 0.5 4.5 | 0.5 2.1 |
| <NULL> | 1 2 | 1 2.3 | 1 2.2 |
| 1.5 3.5 | 1.5 1 | 1.5 1 | 1.5 2.1 |
| 2 3.0 | 2 1 | 2 4.5 | <NULL> |
Depth and measurement values can be tabstop, space ore comma-seperated, doesnt really matter. In a later step I want to route all Measurements into different features using the AttributeExploder and Aggregator while still keeping the depth information.
I realise this could be easily done using the AttributeManager but this would require manually changing the workspace anytime a new dataset is being processed, as the names for Measuremente1-4] may change with each dataset. The DEPTH column is not variable though, so there should be some way to do this? Maybe someone has some insight how I could tackle this problem?
Thanks in advance.
