2 Replies Latest reply: Nov 24, 2016 4:03 PM by Martha Soloch RSS

    Dynamic header

    Martha Soloch

      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 w

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

           

          Where A<>'PersonalNumber';

            • Re: Dynamic header
              Martha Soloch

              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.