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 delimiter is char | no eof | embedded labels | explicit labels | no labels | table is [tablename] | header is n | header is line | header is n lines | comment is string | record is n | record is line | record is n lines | no quotes |msq | URL is string | userAgent is string]
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 |
The table format is a file specifier for the LOAD statement that defines the file type. If nothing is specified, a .txt file is assumed.
txt | fix | dif | biff | ooxml | html | xml | qvd | qvx
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.
Header is line
Header is n lines
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 is commentprefix
Labels is a file specifier for the LOAD statement that defines where in a file the field names can be found.
embedded labels | explicit labels|no labels
The no eof specifier is used to disregard end-of-file character when loading delimited .txt files.
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.
For fixed record length files, the record length must be specified through the record is specifier.
Record is line
Record is n lines
This script specifier is used when loading xml files. Valid options for the XML specifier are listed in syntax.
This script specifier is used when loading KML files to use in a map visualization.
This script specifier is used to set the URL of a web file data connection when loading a web file.
This script specifier is used to set the browser user agent when loading a web file.