This post I will describe you how to exclude files using tFileList component.
Below are our sample files which stored in folder.
From above file list we want to read only files with name starts with “Orders_” and ends with “.csv” therefore we are using tFileList mask to get the file list.
Add tFileList component and configure as follows.
Now you will get all the files from mentioned location but we want to exclude two files which contains “US or USA” so let’s use Advance setting of tFileList and configure as follows.
Here you can see I have use regular expression to exclude files and the regular expression is “Orders_US.*” after running job I will get only one file which I wanted to process here is the output.
If you want to exclude multiple types of file then use comma to separate each pattern like below.