Skip to main content
Question

Build new feature from concatenated values


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

5 replies

danilo_fme
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • May 17, 2020

Hi @boubcher

I simulated your case here:

Result:

 

Thanks in Advance,

Danilo


takashi
Influencer
  • 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
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • May 17, 2020
danilo_fme wrote:

Hi @boubcher

I simulated your case here:

Result:

 

Thanks in Advance,

Danilo

Workspace template - _Workspace_List.fmwt


takashi
Influencer
  • May 17, 2020
takashi wrote:

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
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • May 17, 2020
takashi wrote:

Exactly same as @danilo_fme's solution!

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



Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings