Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • General
  • Hello everyone, I am relatively new to FME and have been given a workspace with little background knowledge passed on to me. So any help would be very much appreciated! For the Diliminated EOE and Road Signs parts I have to merge around 20 excel

spreadsheets together and then insert them into the two inputs. Is there a way I can do this merge via FME by selecting all the worksheets I want merged? As currently it takes 1hour+ to do this manually!snip 

Also I would love to have the ability to extract multiple jpg image filepaths from multiple folders in one go. Is there a way i can just select a folder and say I want all jpg image filepaths extracted from all folders within? I have the ability to do this in Command Prompt but it takes a long time and I know FME would be much faster if it can do it.

 

Any help would be very much appreciated, thank you

Hi, for a more correct answer, please provide CSV samples .

To read the paths to jpg, use the names of directories and files https://docs.safe.com/fme/2021.0/html/FME_Desktop_Documentation/FME_ReadersWriters/path/PATH_reader.htm

Reply


Community Stats

30,166
Posts
114,513
Replies
37,821
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.