![Evil or Very Mad :evil:](./images/smilies/icon_evil.gif)
I need to process an unknown number of files in a directory using a wildcard pattern. Yes, all have the same metadata and there's no header row to worry about.
Rather than use a Folder stage with its potential size issues or a before-job script, I thought I could simply put the 'wildcarded' filename in the File Name field and put 'cat' in the Filter command. I tried putting '/dev/null' in the File Name and the full just 'cat #FILE_PATH#/XXX*.csv' command in the Filter command. Nope. I either get an Error 11 trying to View the data or it crashes my entire Designer session.
![Confused :?](./images/smilies/icon_confused.gif)
Has anyone done this? What is the trick?
In the meantime, I'm cat'ting the files before job to a fixed filename as a 'work around' but I'd really rather not do that if possible.