Format specification items

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 |

Character set

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 | parquet | json |

Table format

For delimited table files, an arbitrary delimiter can be specified through the delimiter is specifier. This specifier is relevant only for delimited .txt files.

delimiter char

For XML, Excel, JSON, or nested Parquet files, Table is specifies the table to load from the file.

table-is char

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 n

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.

no-eof

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.

no quotes

msq

For fixed record length files, the record length must be specified through the record is specifier.

record-is n

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.

xmlsimple

XML

This script specifier is used when loading KML files to use in a map visualization.

KML