Skip to main content
  • EN

I have just started using FME.

I am working on a Feature class that have multiple fields that has "Year" values.

what i have1

 

I am trying to bring my multiple year field values into one field and create a new table.

what i want

I have been banging my head on this problem for few days now but no luck there, so I will really appreciate some workflow to work on with

Thanks in advance

H

I'm not certain I understand your requirements clearly but it seems like you want to transpose the feature class?

If that is the case, attached is a workspace which is derived from the transpose table example from this article.

I'm not certain I understand your requirements clearly but it seems like you want to transpose the feature class?

If that is the case, attached is a workspace which is derived from the transpose table example from this article.

Thanks @debbiatsafe​ for quick response. I basically want to combine values from multiple Columns into one field/Column, as shown in the image here, i have also attached an excel table as an example. Capture

Thanks @debbiatsafe​ for quick response. I basically want to combine values from multiple Columns into one field/Column, as shown in the image here, i have also attached an excel table as an example. Capture

You should be able to use an AttributeExploder to do this fairly easily

Capture

If you need to keep some of the other attribute values that go along with the year dates that requires a bit more work

Thanks @debbiatsafe​ for quick response. I basically want to combine values from multiple Columns into one field/Column, as shown in the image here, i have also attached an excel table as an example. Capture

thanks @ebygomm​ it finally got it right, super easy.. thanks for the help ..cc

Reply


Community Stats

30,187
Posts
114,580
Replies
37,853
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.