newbie trying to read multiple spreadsheets

Do all the input spreadsheets have the same structure, i.e. sheet names, column names etc.?

Hi Ebygomm,

thanks for the reply. Yes, the speareadsheets all have the same structure, sheetnames and columns, etc.

macsmith

@macsmith You can combine two FME operations to do this.

Select Multiple Files/Folders: this browser allows you to select a folder and then optionally read all subfolders:

Then select Single Merged Feature Type.

thanks Markatsafe.

That looks very interesting. I'll try it out in the morning.

Many thanks

macsmith

Hi Markatsafe,

I've tried your suggestion with mixed results. It does discover and read the various spreadsheets, creating one data set. I tried to figure out how to unscramble the data set as I would like to write out a new spreadsheet with one worksheet from each input spreadsheet.

Using my actual data spreadsheets was too cluttered, so I created 3 simple 2 worksheet example spreadsheets and read them in instead. However, the resulting dataset, as displ[ayed in Visual Preview, still showed collumns from the original data set as well as the new, even when I created a new workspace and tried again.

I then completely exited FME and restarted with a fresh workspace. That worked and all the data from the 3 simple spreadsheets was visible in Visual Preview. However, in re-running the workspace, Visual Preview now only displays data from the first of the three spreadsheets. Re-running makes no difference.

So I'm a bit puzzled.

macsmith

I've tried the suggestion with mixed results. It does discover and read the various spreadsheets, creating one data set. I tried to figure out how to unscramble the data set as I would like to write out a new spreadsheet with one worksheet from each input spreadsheet.

Using my actual data spreadsheets was too cluttered, so I created 3 simple 2 worksheet example spreadsheets and read them in instead. However, the resulting dataset, as displ[ayed in Visual Preview, still showed collumns from the original data set as well as the new, even when I created a new workspace and tried again.

I then completely exited FME and restarted with a fresh workspace. That worked and all the data from the 3 simple spreadsheets was visible in Visual Preview. However, in re-running the workspace, Visual Preview now only displays data from the first of the three spreadsheets. Re-running makes no difference.

So I'm a bit puzzled.

macsmith