Skip to main content
Solved

Join multipe excel files with multiple sheets

  • January 15, 2025
  • 1 reply
  • 38 views
yahyanar
Contributor
Forum|alt.badge.img+2

I have 3 Excel files and each one has multiple sheets [T1(sheet1, sheet2..,etc), T2 (sheet1, Sheet2,..etc), T3(sheet1, sheet2,...etc). The names of the sheets in all files are identical and the name of the fields in each sheet are identical too but fill with different data. I need to join or merge each sheet from one Excel file with the corresponding one from the others based on a common field (ID) and have one excel file. 

I did different attempts but I did not get the right results. Could you help please.

Best answer by liamfez

When you are reading in the excel files, you can expose the fme_feature_type attribute for the sheet names and the fme_basename for the workbook/file name. You can use something like the FeatureJoiner to join on your ID field and the fme_feature_type (the sheet).

    1 reply

    liamfez
    Influencer
    Forum|alt.badge.img+44
    • liamfezInfluencer
    • Influencer
    • Best Answer
    • January 15, 2025

    When you are reading in the excel files, you can expose the fme_feature_type attribute for the sheet names and the fme_basename for the workbook/file name. You can use something like the FeatureJoiner to join on your ID field and the fme_feature_type (the sheet).

    Rotate monitor to the right to improve translation speed using gravity
    DanAtSafe
    yahyanar

    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.