I have an attribute [complete] withe the value 1-A.
I would like to split that value to attribute [split1] with the value 1
and attribute [split2] with the value A
I've tried AttributeSplitter;AttributeTrimmer;AttributeCreator
Solved
Split attributevalue into 2 different attributes
Best answer by courtney_m
Use an AttributeSplitter with "Attribute to Split" set to complete, and Delimeter set to a dash (-). Then use a ListExploder to on the list attribute created by the splitter. You can then use a FeatureMerger to merge the records back together.
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.
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.
+19- Contributor
- 127 replies
- Best Answer
Use an AttributeSplitter with "Attribute to Split" set to complete, and Delimeter set to a dash (-). Then use a ListExploder to on the list attribute created by the splitter. You can then use a FeatureMerger to merge the records back together.
+22- Contributor
- 2179 replies
Use an AttributeSplitter with "Attribute to Split" set to complete, and Delimeter set to a dash (-). Then use a ListExploder to on the list attribute created by the splitter. You can then use a FeatureMerger to merge the records back together.
+20- Safer
- 3719 replies
Hi @kees_v, you can accomplish this using the AttributeManager as well. If you're splitting by only one character on each side of the -, you can set the transformer parameters as they are below:
+19- Contributor
- 127 replies
Or follow the AttributeSplitter by an AttributeCreator to create [split1] with value _list{0} and [split2] with value _list{1}.
Use an AttributeSplitter with "Attribute to Split" set to complete, and Delimeter set to a dash (-). Then use a ListExploder to on the list attribute created by the splitter. You can then use a FeatureMerger to merge the records back together.
- 7843 replies
Use an AttributeSplitter with "Attribute to Split" set to complete, and Delimeter set to a dash (-). Then use a ListExploder to on the list attribute created by the splitter. You can then use a FeatureMerger to merge the records back together.
Anyway, I think the AttributeSplitter would be a general way to split a string by a specific separator character or string.
+44- Influencer
- 3434 replies
Hi @kees_v, you can accomplish this using the AttributeManager as well. If you're splitting by only one character on each side of the -, you can set the transformer parameters as they are below:
e.g.
