Skip to main content
Solved

Attribute to value, assign attribute's value to a new attribute

  • April 13, 2021
  • 5 replies
  • 28 views

Forum|alt.badge.img

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:

 

DateSplit 

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?

Best answer by nielsgerrits

Three features. It's supposed to be a time series.

One way to do this is using an AttributeExploder:

2021-04-13_14h38_08

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.

5 replies

nielsgerrits
VIP
Forum|alt.badge.img+60
  • 2938 replies
  • April 13, 2021

Do you want to have 3 features or 3 attributes in a single feature?


Forum|alt.badge.img

Do you want to have 3 features or 3 attributes in a single feature?

Three features. It's supposed to be a time series.


nielsgerrits
VIP
Forum|alt.badge.img+60
  • 2938 replies
  • Best Answer
  • April 13, 2021

Three features. It's supposed to be a time series.

One way to do this is using an AttributeExploder:

2021-04-13_14h38_08


Forum|alt.badge.img

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.


nielsgerrits
VIP
Forum|alt.badge.img+60
  • 2938 replies
  • April 14, 2021

Three features. It's supposed to be a time series.

This is because the AttributeExploder parameter Keep Attributes was set to Yes.