Content Comparison

Job entry name

The name of this entry as it appears in the transformation workspace.

Include subfolders

Check this option if you want to include subfolders. Note: This option will only work when the source is a folder.

Destination is a file

PDI will consider destination a file.

Copy empty folders

Check this option to also copy empty folders.

Create destination folder

This option will create a folder; if destination is a file, parent folder will be created as necessary.

Replace existing files

If the destination file or folder exists, this option will replace it, otherwise PDI will ignore it.

Remove source files

Remove the source files after copying. Only files will be removed.

Copy previous results to args

Check this option to pass the results of the previous entry to the arguments of this entry. Note: Arguments must be in the following order: 1) source folder/file, 2) destination folder/file, 3) wildcard.

File/Folder source

Enter the file or folder to be copied. Note: If destination is a folder, PDI will only fetch the files within the folder if the Include Subfolders option is checked. Note: You can use the Add button to add a line to the Files/Folders list.

File/Folder destination

Enter the destination file or folder.

Wildcard (RegExp)

Allows you to use wildcard expressions to specify source or destination files or folders.

Files/Folders:

Table displays copying parameters set in the fields above after pressing the Add button.

Add files to result files name

Add destination files to result files nameEntry Name

Indicates the name of the step.

Source Environment

Indicates the file system or specific cluster on which the item you want to input can be found.  Options are Local and <Static>.

• Local: Specifies that the item specified in the File/Folder field is in a file system that is local to Spoon.
• <Static>: Specifies that the item specified in the File/Folder field should use the path name in that field, exactly.  Use this if you already know a file path and you simply want to copy and paste it into the window.

Source File/Folder* *

The file or directory to copy from.  If you choose an option other than <Static> in the Source Environment field, click the button in the field to view the Open File window.

Wildcard

Defines the files that are copied in regular expression terms (instead of static file names), for instance: .*\.txt would be any file with a .txt extension.

Destination Environment

Indicates the file system or specific cluster where you want the file to be placed.  Options are Local and <Static>.

• Local: Specifies that the item specified in the File/Folder field is in a file system that is local to Spoon.
• <Static>: Specifies that the item specified in the File/Folder field should use the path name in that field, exactly.  Use this if you already know a file path and you simply want to copy and paste it into the window.

Destination File

Indicates the name of the destination environment. If you choose an option other than <Static> in the Destination Environment field, click the button in the field to view the Open File window.

Include Subfolders

If selected, all subdirectories within the chosen directory will be copied as well

Destination is a file

Determines whether the destination is a file or a directory

Copy empty folders

If selected, will copy all directories, even if they are empty the Include Subfolders option must be selected for this option to be valid. (Wildcard MUST be blank for this to work)

Create destination folder

If selected, will create the specified destination directory if it does not currently exist

Replace existing files

If selected, duplicate files in the destination directory will be overwritten

Remove source files

If selected, removes the source files after copy (a move procedure)

Copy previous results to arguments

Copies the previous results to arguments.

Add files to result files name

Any files that are copied will appear as a result from this step; shows a list of files that were copied in this step

Open from Folder

Indicates the path and name of the directory you want to browse.  This directory becomes the active directory.

Up One Level

Displays the parent directory of the active directory shown in the Open from Folder field.

Delete

Deletes a folder from the active directory.

Create Folder

Creates a new folder in the active directory.

Name

Displays the active directory, which is the one that is listed in the Open from Folder field.

Filter

Applies a filter to the results displayed in the active directory contents.