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?