Skip to main content
Question

Build new feature from concatenated values

  • May 17, 2020
  • 5 replies
  • 20 views

boubcher
Contributor
Forum|alt.badge.img+11

Hello there

we have this type of structure in our data

Attvaluecity1ph1,ph2,ph3

 

and we want to get this structure

attvaluecity1ph1city1ph2city1ph3

 

Any idea, please

Thank you

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

danilo_fme
Celebrity
Forum|alt.badge.img+52
  • Celebrity
  • May 17, 2020

Hi @boubcher

I simulated your case here:

Result:

 

Thanks in Advance,

Danilo


takashi
Celebrity
  • May 17, 2020

Hi @boubcher, you can use the AttributeSplitter to split the "value" at comma and store individual elements into a list attribute, then use the ListExploder to duplicate the feature for each element of the list.


danilo_fme
Celebrity
Forum|alt.badge.img+52
  • Celebrity
  • May 17, 2020

Hi @boubcher

I simulated your case here:

Result:

 

Thanks in Advance,

Danilo

Workspace template - _Workspace_List.fmwt


takashi
Celebrity
  • May 17, 2020

Hi @boubcher, you can use the AttributeSplitter to split the "value" at comma and store individual elements into a list attribute, then use the ListExploder to duplicate the feature for each element of the list.

Exactly same as @danilo_fme's solution!


danilo_fme
Celebrity
Forum|alt.badge.img+52
  • Celebrity
  • May 17, 2020

Exactly same as @danilo_fme's solution!

@takashi We had the same thought on the same time :)