Extracting data from Excel

[madhumitha]

Hello All,

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?

Primary Doc no	ADXXXXXX
Primary Date Start	DD-MM-YYY
Primary Date End	DD-MM-YYY
Primary Reference	125
Secondary Doc no	ADXXXXXX
Secondary Date Start	DD-MM-YYY
Secondary Date End	DD-MM-YYY
Secondary Reference	125
Completeness	% Complete
Some long Text	XX%
	Break Down
	ABC	15
	QEF	12
	REF	3
	GAR	2

[Ralf_Heukäufer]

Hello,

can you upload an example Excel file?

[madhumitha]

Hi ,

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

[Ralf_Heukäufer]

For that you can use:

LOAD

    "E-Doc name",

    "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

[madhumitha]

Thanks Ralf.

It extracts data.

Is there anyway I could stop the extraction when QV finds a newline in the excel?

[Ralf_Heukäufer · Accepted 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

[Ralf_Heukäufer]

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.

[madhumitha]

Sure Ralf.

I will do that thanks!