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:
|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).|
NoteTo view a sample transformation in the PDI client, open the /design-tools/data-integration/samples/transformations/File exists – VFS example.ktr sample file.