Discussion Board for collaboration on QlikView Scripting.
Below is the format of my source excel. I am trying to extract the break down fields (both Alphabet and the numbers) as a different table in my script. How should I approach it?
Go to Solution.
I think not directly,
you can save the number of lines to a variable and work with an if clause in the next read like:
if (rowno() > myvaraible, exit script)
or you can read a fixed number of lines with the first command:
First ‒ Qlik Sense
can you upload an example Excel file?
I have attached the excel.
I am trying to extract E-Doc Name and No of Queries into one table in QV.
Thanks in Advance
For that you can use:
"NO of Queries"
FROM [lib://Path to your File/Sample.xlsx]
(ooxml, embedded labels, header is 20 lines, table is Sheet1);
header is 20 lines says here he begins to read after line 20 as header
It extracts data.
Is there anyway I could stop the extraction when QV finds a newline in the excel?
Is that what you wanted to know, or did I misunderstand your second question?
If the answer was correct please mark your Your Question as correct.
I will do that thanks!