Skip to main content
  • EN
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
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

Reply


Community Stats

30,351
Posts
115,341
Replies
38,081
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.