I have xls table with huge datas about inspection for different zones as shown in attached picture (this is the small example).
How can I write text values from "Area n." column to "Area"?
F.e. for rows with "Area n" 1, 12, 3 I want write East gate in "Area" column and etc.
Thx
Look into the Excel writer template file and the named ranges option:
http://docs.safe.com/fme/html/FME_ReadersWriters/FME_Readers_Writers.htm#xlsx/XLSX_writer.htm%3FTocPath%3DFME%2520Readers%2520and%2520Writers%7CMicrosoft%2520Excel%2520(XLSXR%252FXLSXW2)%2520Reader%252FWriter%7CWriter%7C_____1
David
I'm not sure how the table should be transformed.
Do you need to add the area name to the "Area" column like this?
Takashi
You parralely (..is that a good word??) read the variable (using a VariableFetcher) into Area attribute.
Or you can simply use a conditional attribute creator with adjacent feature reading. (though with big data this will use more memory,( i have scripts that crash on memoryusage when using adjacent featuresettings)
Yes, It should looks like on your picture...
Many Thanks!