I have several excel sheets that have same/similar structures, although some are missing their header names. I can migrate them to SQL Server one-by-one using FME. But I want to loop over the contents of my folder (i.e the excel files) and migrate them all in one go. How do I loop over them? I want to use the same header names for the files missing them as the ones that have them - the header names.
Solved
Loop over a folder's items (i.e. excel files)
Best answer by itay
Hi @mahdy1989,
I would also use the Directory and File path reader as @erik_jan suggests, however I would use a FeatureWriter in the same workspace to create the tables instead of a second workspace.
Hoet this helps.
Itay
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.
for example,
abc1.xls --> dbo.abc1
abc2.xlsx --> dbo.abc2
...
abc25.xls --> dbo.abc25
abc26.xls --> dbo.abc26
abc27.xlsx --> dbo.abc27
+26- Contributor
Not a complete answer, but a good start:
Have a look at the "Directory and File path" reader.
That reader returns the names of the files in the folder you point it to.
Then use the file names to crate a table name.
Use a WorkspaceRunner to kick off your workspace that reads and writes one file.
Use published parameters to pass the file and table name to that workspace.
Hope this helps.
+19- Supporter
- Best Answer
Hi @mahdy1989,
I would also use the Directory and File path reader as @erik_jan suggests, however I would use a FeatureWriter in the same workspace to create the tables instead of a second workspace.
Hoet this helps.
Itay
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.