File tab

File tab

On the File tab, you can define basic properties about the file being created by this step.

Option

Description

Filename

Specify the file name and location of the output file. Click Browse to display the Open File window and navigate to the file or folder. For the supported file system types, see Connecting to Virtual File Systems.

Do not include a file extension when the date and time are to be appended and the Extension option is specified.

Pass output to servlet

Select to return the data using a web service instead of writing to a file (see Web services steps for information).

Create Parent folder

Clear if you do not want to create a parent folder for the output file.

Do not create file at start

Select to avoid the creation of empty files when no rows are processed.

Accept file name from field?

Select to assign the output file name(s) as found in the input stream and selected using the File name field option.

This setting can be fine-tuned with the Kettle properties file. See Improving performance when writing multiple files.

File name field

Specify the field in the input stream that will contain the file name(s) at runtime.

Extension

Specify the three-letter file extension to append to the file name. The default is .txt.

Include stepnr in filename?

Select to include the copy number in the file name (_0, for example) when you run the step in multiple copies (launching several copies of a step).

Include partition nr in filename?

Select to include the data partition number in the file name.

Include date in filename?

Select to include the system date in the file name (_20181231, for example).

Include time in filename?

Select to include the system time in the file name (_235959, for example).

Specify Date time format

Select to include the date time in the file name using a format from the Date time format drop-down list.

Date time format

Select the date time format.

Add filenames to result

Clear if you do not want to add file names to the output file.

Click **Show filename\(s\)** to display a list of the files that will be generated. This is a simulation and depends on the number of rows that go into each file.

Last updated

Was this helpful?