Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
vchuprina
New Contributor II

How dynamically identify the row where data start?

I received files with different row where data start. Sometimes this data start from 10 row, sometimes in 13.

Header.png

In picture you can see part of my file.

Part of my script:

FROM

[\\449629-file1\Data - new\Current\MIS-IB004*.xlsx]

(ooxml, embedded labels, header is 6 lines);

So how dynamically identify header row?

3 Replies

Re: How dynamically identify the row where data start?

Use a where clause that checks the data in the row to see if it should be loaded or not. For example:

LOAD *

FROM ....

WHERE Len(Trim(MyField))>0;

In the above Len(Trim(MyField))>0 checks if the field MyField contains a non-null value.


talk is cheap, supply exceeds demand
vchuprina
New Contributor II

Re: How dynamically identify the row where data start?

I have different header line

Re: How dynamically identify the row where data start?

Community Browser