Discussion Board for collaboration on QlikView Scripting.
Is there any way to load a single cell to a variable from a provided spreadsheet??
Lets say i have the below table on excel.
and I want to load the value 2000 to the variable vValue.
Is there any way to achieve that?? Or any condition that you can use to take row 2 and column 2 cell??
Go to Solution.
You can use peek() function.
LOAD * INLINE [
let vValue= peek('Value',1)
let vValue = FieldValue('Value',2);
This seems to help,
but what about data that are not in a table??
Can I load data from an excel only 2 rows and 2 columns from the entire file by using a condition, and then exctact the value??
I just want the 2000 value to extract from the file.
Load the excel file, then use the function to extract the data required, then drop the excel table.
Drop Table ExcelFileName ;
The excel file is too big can I load only the first 2-3 rows somehow???
B as Value
(ooxml, no labels)
let vValue = FieldValue('Value',1);
Load only B:2 cell from sheet1
you can use First() function.
First 5 Load * from Excel.xls;
[..\Cell to variable.xlsx]
(ooxml, embedded labels, table is Sheet1)
WHERE(Country = 'US');
Let vValue = peek('Value',0);