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.
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.
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.

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!