Skip to main content Skip to complementary content

Header is

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

Syntax:  

header is n

header is line

header is n lines

 

The header length can be given in bytes (header is n), or in lines (header is line or header is n lines). n must be a positive integer, representing the header length. If not specified, header is 0 is assumed. The header is specifier is only relevant for table files.

Example:  

This is an example of a data source table containing a header text line that should not be interpreted as data by QlikView.

 
*Header line Col1,Col2 a,B c,D
 

Using the header is 1 lines specifier, the first line will not be loaded as data. In the example, the embedded labels specifier tells QlikView to interpret the first non-excluded line as containing field labels.

 
LOAD Col1, Col2 FROM header.txt (txt, embedded labels, delimiter is ',', msq, header is 1 lines);
 

The result is a table with two fields, Col1 and Col2.

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!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com