The Data File Parameters form is where you specify additional parameters related to the data file (e.g. format details, new or blank line handling, etc). It's accessible from any group or job by clicking the File Parameters link.
![]() |
The bottom part of the form (shown in red) is slightly different for exports and loads.
|
Group/Job Name: Shows the name of the group or job for which you are currently viewing/editing the data file parameters. This field is read only.
Number of Columns: This field shows the number of columns in a data file.
Worksheet Name: This field is only available if the data file format is Excel. It contains the name of the worksheet to read or create in the Excel file.
Header Row: Indicate if the data file contains a header row.
Character Encoding: Indicate the encoding of the data file. Values supported are ANSI (default), UTF8 and Unicode.
Columns Separator: Character(s) used to separate columns in a "Text with separator" data file. The default is the vertical bar ( | ) aka pipe character.
Comment Char(s): Character(s) used to specify a comment line in the data file. Lines beginning with these character(s) are ignored when a data file is read.
Quote Char(s): Indicate whether the quote character is single quote or double quotes.
New Line Handling: Indicate how to handle new line characters encountered in exported data.
You can use any of the 3 options:
Append to Existing File: If this box is checked, DMT tries to append exported data at the end of an existing data file. If the data file doesn't exist, it's created. If the data file already exists, exported data is added at the end of it.
Note: To append data at the end of an existing data file, it's recommended to use a data group rather than this check box.
Blank Line Handling: Indicate how to handle blank lines encountered while reading a data file.
You can use any of the 3 options: