The loading of multiple files in one pass is best undertaken as a host script.
A generated host script contains the code to handle wild card loads and the subsequent loading and renaming of multiple files. The process for setting up wild card loads is as follows:

  1. Drag one of the files into a Load Table target and select one of the Script based options.
  2. If necessary edit the generated script and replace the load file name with the required wild card version. (For example test_result_234.txt renamed to test_result_*.txt. This load file name is defined as a variable at the start of the script.
  3. If renaming or moving to another directory is required, then you may need to uncomment the rename phase and enter the desired directory or rename syntax.
  4. If only one file at a time is to be processed, but still based on a wild card file name, then you may need to uncomment the break statement at the bottom of the script. This will result in the loading of only the first file encountered that matches the wild card criteria.

In every event, check the generated script as it will contain instructions on how to handle wild cards for the appropriate script type (Windows or UNIX).

  • No labels