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

30,370
Posts
115,382
Replies
38,145
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.