Each format specification item defines a certain property of the table
file:
fspec-item ::=
[ ansi | oem | mac | UTF-8 | Unicode | txt | fix | dif | biff | ooxml |
html | xml | kml | qvd | qvx | parquet | delimiter ischar | no
eof | embedded labels | explicit labels | no labels | table is [tablename] | header isn | header isline | header isnlines | comment isstring | record
isn | record isline | record isnlines
| no quotes |msq | URL isstring | userAgent isstring]
Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.
Character set is a file specifier for the LOAD statement that defines the character set used in the file.
ansi | oem | mac | UTF-8 | Unicode | codepage is |
For delimited table files, an arbitrary
delimiter can be specified through the delimiter
is specifier. This specifier is relevant only for delimited .txt
files.
Specifies the header size in table files. An arbitrary header length can be specified
through the header is specifier. A header is a text section not used by Qlik Sense.
If you have lines in your source data file that are comments, you can define a comment prefix with Comment is. Set commentprefix to the character or string that comment lines start with, and these lines will be ignored when you load data.
Comment iscommentprefix
Labels is a file specifier for the LOAD statement that defines where in a file the field names can be found.
Quotes is a file specifier for the LOAD statement that defines whether quotes can be used and the precedence between quotes and separators. For text files only.