I have got a spreadsheet with some values stored in a column. Now I need to extract this into Qlikview and store the values of different rows of the column into separate variables in Qlikview.
How do I do that?
LOAD Field FROM [File.xlsx] (ooxml, embedded labels);
Let vVariable1 = peek('Field',0,''ExcelData'); // Row 1
Let vVariable2 = peek('Field',1,''ExcelData'); // Row 2
That worked.. Thx!!
Here is an example that shows how I mean. Put both files in the same folder and it will work. The script also contains a loop that you can use if you want to define both Names and Values of the variables in the Excel sheet.
Retrieving data ...