Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wcilliers
Partner Ambassador
Partner Ambassador

Load and Join with multiple QVD's

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

Labels (1)
0 Replies