I’m using CloverETL designer 3.1.x. I made use of the XLSReader component to read excel files. My concern is to read all files ending with a .xlsx extension.
I put in excel files in a folder structure like - C:\TEST\.
I used syntax - C:/TEST/*.* as my file URL, which worked perfectly.
Now I put in a sub folder inside TEST called TEST1 - C:\TEST\TEST1 which contains excel files as well. I was hoping to use the above syntax to read files inside the sub folder as well, which didn’t work out.
Is there a way to read files inside the sub directory using any components ?
First of all I would recommend to upgrade your Designer as versions prior to 4.0 are no longer officially supported.
However reading files from any subfolder is done exactly the same way as reading from root folders.
C:/TEST/TEST1/*.*
You can even set more than one path using semicolon as a delimiter.
C:/TEST/*.*;C:/TEST/*/*.*
Please keep in mind, that the slashes must face forward regardless your OS. Please check whether you set everything properly. If your issue persists and some kind of error occurs, please send me a runlog (preferably in DEBUG mode) and/or screenshot of that error. If there is no error message, please send me your graph file (*.grf), so I can check it out.