Skip to main content
Solved

Processing multiple Raster into a single excel output

  • July 24, 2013
  • 1 reply
  • 44 views
K
Hello,

 

 

I am new to the FME and I have certain task to finish.

 

 

I have about 20 raster images and I need to find mean of cell values per leagal description (Township) in Alberta. I have created a workbench which uses:

 

 

- RasterCellCoercer

 

- CoordinateExtractor

 

- Clipper

 

- StatisticsCalculator

 

 

to get statistics for one Raster image and the result is stored in Excel. I am wondering if there is a way to add the results of the other raster images to the excel file (adding columns for each raster).

 

 

P.S. I am using FME 2011 SP1

Best answer by takashi

Hi,

 

 

I think it's difficult to append columns to an existing Excel spread sheet. If adding rows satisfies your purpose as a substitutional solution, you can do that with the Excel writer settings like this: Overwrite Existing File: No Writer Mode: INSERT

 

 

Takashi
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.

1 reply

takashi
Celebrity
  • takashiCelebrity
  • Best Answer
  • July 25, 2013
Hi,

 

 

I think it's difficult to append columns to an existing Excel spread sheet. If adding rows satisfies your purpose as a substitutional solution, you can do that with the Excel writer settings like this: Overwrite Existing File: No Writer Mode: INSERT

 

 

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

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.