Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get the header row number

Hi All,

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

Thanks,

Asma

4 Replies
awhitfield
Partner - Champion
Partner - Champion

Hi Asma,

You can use RecNo() in your load script:

HTH Andy

jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
qlikviewwizard
Master II
Master II

User Rownum function.

Gabriel
Partner - Specialist III
Partner - Specialist III

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.