Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In page 430, the book tells me to load file Intervals.xlsx from the folder "..\ Qlikview Development\Airline Operations\1.Source Data\Examples".
The script turns out to be -
Elements:
LOAD ID,
Start,
End
FROM
[..\1.Source Data\Examples\Intervals.xlsx]
(ooxml, embedded labels, table is Intervals);
This loads correctly. But, the book replaces "table is Intervals" with "table is Elements".
I tried using elements instead of intervals and got the error - "Field not found" ID. Is this a mistake ?
(The book also replaces all columns in the above script with "Element" which is used in an IntervalMatch() later,
but I ignore that for now.)