PDI - Loading Multiple files based on reg exp...

                 Let's have a look on PDI transformation to load multiple files at a time using regular expression.

Step 1: Drag a Getting file name function from Input .

Step 2: Double click on it and provide the file directory from where to pick the files.

Step 3: Then, on Regular Expression, give the file previx followed by .*\. filepostfix.

                    For Ex. File_.*\.txt 

Step 4: Then, press the add button and give show filenames. File names will be listed from that directory based on the file prefix (File_) and file postfix(txt).

Step 5: Now, drag the table output and load the files.

Thanks,

Dilip