I have just started using FME.
I am working on a Feature class that have multiple fields that has "Year" values.
I am trying to bring my multiple year field values into one field and create a new table.
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
Best answer by ebygomm
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. 
You should be able to use an AttributeExploder to do this fairly easily
If you need to keep some of the other attribute values that go along with the year dates that requires a bit more work
+20I'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.
+31Thanks @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.
You should be able to use an AttributeExploder to do this fairly easily
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.
thanks @ebygomm it finally got it right, super easy.. thanks for the help ..
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
