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.
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
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.