How dynamically identify the row where data start?

[vchuprina]

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]

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]

I have different header line

[Gysbert_Wassenaar]

Please read these two documents:

• QlikCommunity Tip: How to get answers to your post?
• Preparing examples for Upload - Reduction and Data Scrambling