Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Is it possible to get the row number where the column names are present in an excel file in qlikview?
Thanks,
Asma
Hi Asma,
You can use RecNo() in your load script:
HTH Andy
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.
User Rownum function.
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.