Discussion Board for collaboration on QlikView Scripting.
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:
[\\449629-file1\Data - new\Current\MIS-IB004*.xlsx]
(ooxml, embedded labels, header is 6 lines);
So how dynamically identify header row?
Use a where clause that checks the data in the row to see if it should be loaded or not. For example:
In the above Len(Trim(MyField))>0 checks if the field MyField contains a non-null value.
I have different header line
Please read these two documents: