Skip to main content
Question

How to merge excel file with multiple sheets and shapefile

  • August 10, 2018
  • 1 reply
  • 65 views
K

Hi,

I wonder how i can merge an excelfile with several sheets to an shapefile. The shapefile has the location of stations and in the excelfile I have information aout the stations for each station. i.e each station has its own sheet.

I really would lika som help with how i can merge this, please.

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

david_r
Celebrity
  • david_rCelebrity
  • 8391 replies
  • August 10, 2018

If there's a common ID between the Excel data and the shape feautures, the most obvious choice would be to use a FeatureMerger.

If you configure the Excel reader to read the entire Excel file as a single merged feature type, the "fme_feature_type" attribute will contain the sheet name, which you could reference in the FeatureMerger:

Community Stats

32,058
Posts
121,723
Replies
39,686
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.