topic Re: Dynamic header in QlikView

Dynamic header

Tue, 22 Nov 2016 17:48:26 GMT

Hello,

I've to load different tables with diffrent headers. The headers I don't need for the app.

All tables have in common that the titles of the colums are the same (Personalnumer, name, surname, street,...) and the line above the column-titel is empty and in some cases the two lines above the colum-title are empty.

I can't use the line-numbers because it varies.

Has anybody an idea how to tell Qlikview to read the table from the line with the colum-title (Personal number,...) or to read the table after the last empty row or any other idea?

Re: Dynamic header

m_woolf — Tue, 22 Nov 2016 19:03:03 GMT

Syntax will vary depending on the data file type, but something like:

Where A<>'PersonalNumber';

Re: Dynamic header

Thu, 24 Nov 2016 21:03:02 GMT

Hi,

where should I enter this in the code?

FROM

[..\..\..\-.,....csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq, header is 4 lines);

header is 4 lines - is wrong. There should be a dynamic expression like "header is til line with "Personal numer"

or something like this.