Skip to main content

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.

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

Community Stats

32,018
Posts
121,610
Replies
39,637
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.