Does anyone have advice on how to only bring in one file from a zip file where the file names within the zip change every day?
Thanks!
Question
Read only one file from a zip
I have a zip file that contains 2 excel files. The names of the files are dynamic (Name Current Date.xlsx), and there is one tab within each spreadsheet. For both spreadsheets, the tab has the same name. When I try to read the zip file, FME is pulling all the records from both spreadsheets, instead of just the first spreadsheet. Since the tabs are the same name, I can't see a place where I can specify which feature to read.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Hi Erin,
Unless the files are huge, how about just reading everything, then filter the relevant file in your workspace using fme_basename or fme_dataset?
David
Hi Erin,
I can reproduce the behavior. Or you unzipp your folder first and then hit the 'prompt and rund' button of FME. Then you have the full controll which dataset you read...
Or you use the filter option, as David said...
Best regards,
Stefan