File exists (Step)

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.

File exists dialog

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.

Last updated

Was this helpful?