Question

How to merge excel file with multiple sheets and shapefile

  • 10 August 2018
  • 1 reply
  • 15 views

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.


1 reply

Userlevel 4

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:

Reply