Hi Experts,
I am experiencing strange behavior, perhaps normal, but doesn't make sense to me. When loading from multiple QVD's with the same data. Lets say company A and company B.
Header:
Load
Company & TransId as %Key,
*
From [Header*.qvd];
/////////////////////////////////////////////
Left Join (Header)
Load
Company & TransId as %Key,
TotalSales
From [Transactions*.qvd];
This works when there is only 1 qvd for each to read from. When adding more companies, the wildcard load does not seem to be working. I would expect Qlik to load all the transactions into memory before attempting the join, however, this doesn't seem to happen... Am i missing something?
It works when I load the Transactions into a temp table first, then do the join. However, the entire script is based on different companies, and it would have been nice to 'not' load everything into temp tables first. Is this normal behavior?
Any help or suggestions would be greatly appreciated.
Thanks,
Wynand
