Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
on p. 121 of QlikView for Devs Cookbook we have the following:
" Load the following script:
LOAD * INLINE [
Country, City, Sales, Orders
USA, San Diego, 24567, 546
USA, Dallas, 54962, 345
USA, New York, 67013, 678
USA, Boston, 45824, 365
UK, London, 64002, 743
UK, Birmingham, 44291, 572
UK, Manchester, 40320, 534
Germany, Berlin, 52912, 643
Germany, Frankfurt, 61832, 678
Germany, Munich, 35812, 325
Japan, Tokyo, 42137, 562
Japan, Yokohama, 55832, 753
Japan, Osaka, 37643, 418
];
"
Yet the first Step is 'Create a new pivot table with Year and Country as dimensions. '
However, there is no 'Year' dimension in the INLINE LOAD (see above).
Am I missing something?
If is an error in the book, how does one re-structure the INLINE LOAD to produce the Pivot Table as per p. 122 of this textbook?
Refer to pivot_table.png which I attached to this discussion
thanks
attached pivot_table.png
I haven't gone thru page no in Cookbook. But, Looks like Rob may forget to add Year field records missed in Inline Memory.
that was a part of my original post, specifically: '...how does one re-structure the INLINE LOAD to produce the Pivot Table...?'
ta
Like this:
LOAD * INLINE [
Year, Country, City, Sales, Orders
2017, USA, San Diego, 24567, 546
2016, USA, Dallas, 54962, 345
...
];
This error is reported in the Errata page for the book: https://www.packtpub.com/books/content/support/12458
The suggested workaround is to use the load on page 123.
(BTW, that's stephen-x.redmond's book. I'm the publisher of the QlikCookbook.com website)
-Rob