Skip to main content

Hi,

I am working with FME Desktop, and at a certain point, my features have a "Month" field with values such as 10, which refers to October, 11 meaning November, and so on for all months of the year. The table that will receive this value has columns ranging from OCTOBER to SEPTEMBER. How can I make FME understand that if the column has a "Month" value of 10, the "Average" field should be renamed to OCTOBER, ensuring that the values from the recently renamed OCTOBER field are recorded in the table, which also has a column named OCTOBER?

 

Thank´s

Hi ​@mr_fme 

Can you share a picture of the data? From what I understand, you will have a table with a Month Column:

“Month”
1
2
3
4
...

You have another table with Columns:
“January” “February” “March” “April”…..”Average”

And when you Process the two: “Average” will be renamed? And then values will be transferred to the table? If you have an example that would be great.