topic Re: How dynamically identify the row where data start? in QlikView

How dynamically identify the row where data start?

vchuprina — Mon, 26 Jan 2015 10:30:23 GMT

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

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?

Gysbert_Wassenaar — Mon, 26 Jan 2015 10:33:04 GMT

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.

vchuprina — Mon, 26 Jan 2015 11:21:12 GMT

I have different header line

Gysbert_Wassenaar — Mon, 26 Jan 2015 11:23:14 GMT

Please read these two documents: