Skip to main content Skip to complementary content

Table format

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.

Table format types
Type Description
txt

In a delimited text file the columns in the table are separated by a delimiter character.

Delimiter is

fix

In a fixed record file, each field is exactly a certain number of characters.

Typically, many fixed record length files contains records separated by a linefeed, but there are more advanced options to specify record size in bytes or to span over more than one line with Record is.

Record is

Information noteIf the data contains multi-byte characters, field breaks can become misaligned as the format is based on a fixed length in bytes.
dif In a .dif file, (Data Interchange Format) a special format for defining the table is used.
biff Qlik Sense can also interpret data in standard Excel files by means of the biff format (Binary Interchange File Format).
ooxml

Excel 2007 and later versions use the ooxml .xslx format.

The Table is specifier can be used to define the sheet name to be loaded as a table.

Table is

html If the table is part of an html page or file, html should be used.
xml

xml (Extensible Markup Language) is a common markup language that is used to represent data structures in a textual format.

The Table is specifier can be used to define the path of the XML to be loaded as a table.

Table is

qvd The format qvd is the proprietary QVD files format, exported from a Qlik Sense app.
qvx qvx is a file/stream format for high performance output to Qlik Sense.
parquet

Apache Parquet is a columnar storage format, highly efficient for storing and querying large datasets.

With Parquet files containing nested data, you can specify the table from the Parquet file to load using Table is specifier. For example: LOAD * FROM [lib://DataFiles/company.parquet] (parquet, table is [company:salesrep.salesrep]);.

Table is

For more information on loading nested data in Parquet files, see Loading data from nested Parquet files.

json

JSON (JavaScript Object Notation) is a language-independent data format.

If the JSON contains multiple arrays, the Table is specifier can be used to define the path to the iterator for the subtable.

Table is

Learn more

 

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!