I have a list of features. Each has a number of columns with a date as name and as value a numeric value. I want to use the date columns as a new column's attribute value, and write the date column's value into another field, like this:
In this example I'd end up with 3 features. Furthest I've gotten so far was with the AttributeTransposer, however it returns every other field's value as missing and I can't get them back. Any ideas how to accomplish this?
Do you want to have 3 features or 3 attributes in a single feature?
Do you want to have 3 features or 3 attributes in a single feature?
Three features. It's supposed to be a time series.
Three features. It's supposed to be a time series.
One way to do this is using an AttributeExploder:
Three features. It's supposed to be a time series.
Great, that worked. Even with some extra attributes I dragged along, though I can't pinpoint why.
Three features. It's supposed to be a time series.
This is because the AttributeExploder parameter Keep Attributes was set to Yes.