Skip to main content
  • EN

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

Hi @boubcher

I simulated your case here:

Result:

 

Thanks in Advance,

Danilo

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.

Hi @boubcher

I simulated your case here:

Result:

 

Thanks in Advance,

Danilo

Workspace template - _Workspace_List.fmwt

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!

Exactly same as @danilo_fme's solution!

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


Reply


Community Stats

29,736
Posts
112,987
Replies
37,383
Members
Terms & ConditionsCookie settings