Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

Understanding parameters of a LOAD - header lines

Hi,

in one app, I have to load a report we get from a customer where there is a list of data spread across two sheets.

The issue is, both the names of the sheets and the nr. of header lines were different between the report we got in May and the one we got in June.

=> So I tried to make both into variables with Input_fields - that is an option because I have to run it manually anyway, once a month, whenever we have all the data available.

That worked fine with the names of the sheets, but I have an issue with the nr. of header_lines:

Please find attached a small sample that I have taken from that report. I hope that will serve to illustrate the issue:

- When I look at the two sheets, I see that

     - on one, there are 6 lines above the actual headers

     - on the other, there are 5 lines above the actual headers

<=> Both LOADs seem to work fine when I set the nr. of header_lines to 5 - when I set it to 5, a field_name isn't found, so I guess that
       this results in the headers being cut off.

I hope someone can shed some light on this.

Without fully understanding this, I cannot make the nr. of header_lines into variables.

Thanks a lot!

Best regards,

DataNibbler

P.S.: In this example it's even worse - I think one sheet needs to be set to just 3 header_lines - but it serves to illustrate my issue: I don't fully understand the connection between the nr. of lines that I see and the one that I need to set in the QlikView table_wizard.

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi,

Try

LOAD A as Land,
B as Partner,
C as [Verpack Vetrieb],
D as [Versand Datum],
E as [Abw-Art],
F as Sachnr,
G as Bezichnung
FROM
[Community.xlsx]
(ooxml, no labels, table is [Rohdaten I])
Where Len(Trim(A)) > 0 and A <> 'Land';

View solution in original post

2 Replies
antoniotiman
Master III
Master III

Hi,

Try

LOAD A as Land,
B as Partner,
C as [Verpack Vetrieb],
D as [Versand Datum],
E as [Abw-Art],
F as Sachnr,
G as Bezichnung
FROM
[Community.xlsx]
(ooxml, no labels, table is [Rohdaten I])
Where Len(Trim(A)) > 0 and A <> 'Land';

datanibbler
Champion
Champion
Author

Hi Antonio,

so you just don't specify a nr. of header_lines at all, but you just filter out empty lines, is that right?`

That sounds good. I'll try.

Best regards,

DataNibbler