Hi,
I'm trying to automate a process where FME reads in an Excel sheet in a specific format, but i need to split the Sheet into two parts (as they are completely different structures) and treat as two different datasets effectively. Is there a way in the Excel sheet reader to effectively duplicate a sheet in order to choose the different cell ranges that i require?
+17
If the spreadsheet contains two different tables like this, you can just split the data flow from the Excel reader into two streams and write the two tables into different datasets separately.
This screenshot illustrates the basic concept. Depending on the actual structure of the source spreadsheet, probably you should consider some additional processes.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
