Hello, Once a week we receive an excel file. You can see on the attached image how the excel file looks like when you open it with FME Inspector. I would like to create two new tables: one for the new units (row 6 till 9) and one for the new cells (row 14 till 23) including the headers (unit, unit title, south limit etc). How can I extract these rows using FME? The structure is the same every week (new units, then new cells) but the number of rows is variable.
+2
Wow, that's an eccentric structure. There are ways and means, but honestly the easiest by far would be to add named ranges in Excel - is that possible in this instance? If so, you can just read them in as separate tables using the same FME reader.
+17
Hi @kat, I agree that using named ranges is an easy way, but if named range setting is not an option, I would use a global variable to split the source table into sub tables.
@takashi Thank you very much for the solution. It is working great. I've added an attribute creator before the variable retriever otherwise the 'new units' attribute value overwrites the attribute value for column A of the units (aa, bb, etc.). My next question is how can I delete the first row (it's row no 5 on my attached image) of the output for New Units TestFilter and use its values as the attribute name for the subsequent rows instead (for row no 6 - 9 on my attached image)? Thanks again.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
