The File exists step verifies the existence of a file by checking filenames coming from previous steps, and adds a Boolean flag field to the input fields of the output.
The following fields are available to this transformation step:
Field | Description |
---|---|
Step name | Specify the unique name of the File exists transformation step on the canvas. You can customize the name or leave it as the default. |
Filename field | Specify the input field that will contain the filename at runtime. |
Result fieldname | Specify the name of the field that will contain the Boolean (Y/N) flag. |
Add filename to | Select to add the filename to the list of filenames that can be used in the next job entry. |
Include file type | Select to include the file type in the field. |
File type field | Specify the name of the field that contains the file type as a String (for example, file, folder, or imaginary). |
Note: To view a sample transformation in the PDI client, open the
/design-tools/data-integration/samples/transformations/File exists – VFS example.ktr sample file.