Skip to main content
Solved

Join multipe excel files with multiple sheets

  • January 15, 2025
  • 1 reply
  • 22 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).

View original
Did this help you find an answer to your question?

1 reply

liamfez
Influencer
Forum|alt.badge.img+34
  • 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).


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings