topic Re: Get the header row number in QlikView

Get the header row number

Thu, 14 May 2015 07:32:32 GMT

Hi All,

Is it possible to get the row number where the column names are present in an excel file in qlikview?

Thanks,

Asma

Re: Get the header row number

awhitfield — Thu, 14 May 2015 08:17:52 GMT

Hi Asma,

You can use RecNo() in your load script:

HTH Andy

Re: Get the header row number

jonathandienst — Thu, 14 May 2015 08:50:51 GMT

Well, open the file in Excel....

That is probably not what you mean, but I do not really understand your requirement. Please provide more details.

Re: Get the header row number

qlikviewwizard — Thu, 14 May 2015 08:58:11 GMT

User Rownum function.

Re: Get the header row number

Gabriel — Thu, 14 May 2015 10:05:51 GMT

Hi,

When you load from Excel or any source, QlikView list all field header, in case of excel this are the column name.

Your question is about finding the row number of the header. In qlikview even if there are blank rows in excel and the first row that the headers starts from is say row 5, qlikview will not show or list blank rows from row 1 - row 4. QlikView will load the row header and ignore the blank rows.

May be more detailed explanation of your question might help.