Never think you know it all! Today I have for you a little ‘gotcha!’ about the LOAD DISTINCT statement that I picked up from Oleg Troyansky at the Masters Summit for QlikView.
Common knowledge about LOAD DISTINCT is that it will remove duplicate records from the input table, similar to how the DISTINCT clause works in SQL. For example:
However, when used in combination with the JOIN or CONCATENATE statement, the results can be surprising, and even counterintuitive.
As you may have read or seen elsewhere already, the 24th of June saw a new addition to the QlikView library; Stephen Redmond‘s QlikView for Developers Cookbook. Categorized into 11 chapters, this new book contains self-contained recipes that show you how to achieve various tasks in QlikView.
The book is available via the following online stores:
 |
 |
I was delighted to be a technical reviewer for this book, and honored when Stephen asked me if I’d write a foreword for him. For those interested in the foreword, I’ve included it after the break.
Learn Qlik, the Qlik APIs and Web Development at your own pace at Websy Academy
Supercharge your QlikView designs
(c) 2010 - 2024 