Skip to main content
Solved

Merge Feature Types in CSV Reader

  • August 6, 2014
  • 1 reply
  • 11 views

Forum|alt.badge.img
I have a problem where I am trying to load a specifically named .csv file into FME. Basic right!?!? The problem is that the dataset I am loading is broken up in subfolders.

 

 

For example, I am opening “Folder A” with a hierarchy of “Subfolder A”, “Subfolder B”, “Subfolder C”, and so on. Within each subfolder is CSV file named “example.csv”.

 

 

I need to batch grab “example.csv” out of each subfolder. I considered using “Merge Feature Type” option but I’m a little rusty on how to structure my *\\**.csv setup.

 

 

I hope I’ve explained this well enough and would appreciate any direction on how to merge the CSV files (of a specific name) as a reader in the subfolders.

 

 

*Note, in the meantime, I manually added the 100+ files as a stopgap but it’s not an elegant or sustainable solution.

 

 

Thanks,

 

 

 

Matt

Best answer by takashi

Hi Matt,

 

 

You can use the Advanced Browser when setting the source dataset.

 

Add root Directory and check Subdirectories column. Then the reader will search all files in specified directory and its subdirectories recursively. And you can also edit File/Filter column to read files having specific file name.

 

 

 

Takashi
View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.

1 reply

takashi
Contributor
Forum|alt.badge.img+19
  • Contributor
  • Best Answer
  • August 6, 2014
Hi Matt,

 

 

You can use the Advanced Browser when setting the source dataset.

 

Add root Directory and check Subdirectories column. Then the reader will search all files in specified directory and its subdirectories recursively. And you can also edit File/Filter column to read files having specific file name.

 

 

 

Takashi

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings