Solved

Data popularization in table

11 years ago
Aug 4, 2015 4:52 AM UTC
6 replies
63 views

sega

Hi for all!

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

Best answer by takashi

This is a solution example based on Gio's suggestion - VariableSetter/VariableRetriever.

View original

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

david_r
11 years ago
Aug 4, 2015 8:08 AM UTC

Hi

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

Upvote

takashi
11 years ago
Aug 4, 2015 9:13 AM UTC

Hi,

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

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

Upvote

+15

gio
Contributor
11 years ago
Aug 4, 2015 2:05 PM UTC

You can achieve this by reading the column "Area n." into a variable for each occasion the value is not a number.

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)