Databases Reference
In-Depth Information
The
File Wizard
tries to determine the
File Type
automatically, and it is pretty
accurate. However, you can easily change it in case it got it wrong, by selecting the
corresponding radio button. As you can see, the file types that can be loaded using
this wizard include:
Delimited
(CSV, TSV, and so on),
Fixed Record
(when the file
does not contain a specific character as a separator, but is consistent with its column
widths),
Excel
iles,
Html
,
Qvd
(QlikView datafiles, like the ones we used in
Chapter
2
,
Seeing is Believing
),
Xml
, and
Qvx
(QlikView eXchange format).
As part of this example, we will further discuss the settings involved when reading a
CSV (delimited) file. The configuration for the rest of the file types is very similar to
this, so we will not go into detail for each of them.
The CSV attributes
Since our CSV file is a delimited file, it is possible to select which character is used as
a separator. This is done via the
Delimiter
drop-down field.
The
Quoting
schema to be used can also be specified, with the available options
of
Standard
,
MSQ
, and
None
. By default (that is, using MSQ), straight double
quotes (" ") and straight single quotes (' ') are permitted for field values, but with
one condition: they must be in both the first and the last non-blank character of a
field value.
In case the table file has more than one line as the header record, you can specify
it in this same window, with the option to set it as a number of lines or number
of bytes.
QlikView can also recognize comment lines in the file, when we specify the
character(s) which identifies a comment line by typing it in the
Comment
field.
The other options we can set are: whether the file has the field names defined in the
header row (
Embedded
) or not, and whether QlikView should ignore an End of File
mark (
Ignore EOF
).
A word on Quoting
If a cell contained in the table being read has only one quotation mark, or if the
quotation marks are not in the first and last non-blank character position, the script
reload will not be correctly executed and the file will not be properly read.
