Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

venkat_94b4
Contributor

loading data from Excel

Hello .

i have an excel file with unknown number of null rows..... i need to load data from where data starts..(avoiding all empty rows)...

Thanks in Advance.

Regards,

Venkat.

1 Solution

Accepted Solutions
gabriel_kirst
Contributor III

Re: loading data from Excel

1. If your header is in the top of the empty rows, how is showed below, you don't need to worry about those empty rows, in the tests that I did here those empty rows do not affected the information.

YearCustomerValue
2007Customer12
2007Customer23
2007Customer34
2007Customer45
2008Customer11
2008Customer24
2008Customer33
2008Customer44

2. This situation with lines before the header is more complicated. I didn't found a way to get the header names on the LOAD. What I did is create a "where" to not bring inside the fields the header name.

For example:

YearCustomerValue
2007Customer12
2007Customer23
2007Customer34
2007Customer45
2008Customer11
2008Customer24
2008Customer33
2008Customer44

LOAD A,

     B,

     C

FROM

[Book1.xlsx]

(ooxml, no labels, table is Sheet1)

where A<>'Year';

Hope it helps.

Gabriel

4 Replies
gabriel_kirst
Contributor III

Re: loading data from Excel

Do you need to load your header information from the excel file?

Regards,

Gabriel

venkat_94b4
Contributor

Re: loading data from Excel

tel me in 2 cases...

1. header is in top row then empty rows...

2.empty rows then header and data...

gabriel_kirst
Contributor III

Re: loading data from Excel

1. If your header is in the top of the empty rows, how is showed below, you don't need to worry about those empty rows, in the tests that I did here those empty rows do not affected the information.

YearCustomerValue
2007Customer12
2007Customer23
2007Customer34
2007Customer45
2008Customer11
2008Customer24
2008Customer33
2008Customer44

2. This situation with lines before the header is more complicated. I didn't found a way to get the header names on the LOAD. What I did is create a "where" to not bring inside the fields the header name.

For example:

YearCustomerValue
2007Customer12
2007Customer23
2007Customer34
2007Customer45
2008Customer11
2008Customer24
2008Customer33
2008Customer44

LOAD A,

     B,

     C

FROM

[Book1.xlsx]

(ooxml, no labels, table is Sheet1)

where A<>'Year';

Hope it helps.

Gabriel

venkat_94b4
Contributor

Re: loading data from Excel

Thanks Gabriel........

Community Browser