How to import a row of data from Excel into Qlikview
I am trying to import a row of data from Excel into Qlikview. Unfortunately, I am unable to change the row (consisting of location ID #'s) to columns due to contractual reasons. I want to have this row of data be treated like a column, in that I want to be able to load it in as shown below so I can use it for reference with SQL Server.
Row 10 has the ID's I need to be able to use to link the entries to the SQL data.
The 'RowNo() = 10' shown below is not working on reading in Row 10. I would really appreciate any help in figuring out how to correctly write this statement to read in Row 10.
If you don't want to load all columns (which you could simplify with the wildcard) you will need to specify each single column - if you used the wizard for the load-statement this won't need much efforts.
To shorten a load-statement you could variables - whereby you will add some complexity and reduce to some degree the readability. But nevertheless you could do:
set vColumns = H, I, J, ....;
load $(vColumns) From YourSource;
Another possibility could be to load all columns with the wildcard and then drop all unwanted columns but this will be only useful if there are much more columns to load then not to load and you will in each case increase the load-times.