I have a column (route_num) with a list of route numbers. How can I extract each route number as it's own feature and all other attributes as copies. See below
From:
To:
Best Answer
Create multiple features from list within an attribute
Best answer by hollyatsafe
Hi @mariofederis,
First use an Attribute Splitter to generate a list of the values in ROUTE_NUM, then use the ListExploder to explode each list member into its own feature with the accumulation mode set to 'Merge List Attributes' and Conflict Resolution to 'Use List Attribute Values'.
Here is an example workspace: listtofeatures.fmw
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.
Hi @mariofederis,
First use an Attribute Splitter to generate a list of the values in ROUTE_NUM, then use the ListExploder to explode each list member into its own feature with the accumulation mode set to 'Merge List Attributes' and Conflict Resolution to 'Use List Attribute Values'.
Here is an example workspace: listtofeatures.fmw
Hi @mariofederis,
First use an Attribute Splitter to generate a list of the values in ROUTE_NUM, then use the ListExploder to explode each list member into its own feature with the accumulation mode set to 'Merge List Attributes' and Conflict Resolution to 'Use List Attribute Values'.
Here is an example workspace: listtofeatures.fmw
Hi @mariofederis,
First use an Attribute Splitter to generate a list of the values in ROUTE_NUM, then use the ListExploder to explode each list member into its own feature with the accumulation mode set to 'Merge List Attributes' and Conflict Resolution to 'Use List Attribute Values'.
Here is an example workspace: listtofeatures.fmw
Hi @hollyatsafe May I have your example workspace for testing, great thanks!
Hi @hollyatsafe May I have your example workspace for testing, great thanks!
Hi @heya ,
Thanks for letting us know the attachment link was broken. I've updated the original answer post so you should be able to access it now.