Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
markgraham123
Specialist
Specialist

QV connecting tables with key - but fails when i try to join

 

Hi All,

 

I'm connecting 2 tables using a key.  It works.

But when i join 2 tables using the same key, it is not able to join and my PC runs out of memory and fails.

Not able to understand what is the issue.

Can someone please help? Attached picture shows connection.

Labels (1)
1 Reply
kswindlehurst
Contributor II
Contributor II

How unique are your KEY values?   You could be asking for a crazy large Cartesian product if it's a small distribution with a lot of records on both sides.   Limited Load is your friend - try it with smaller sets of data and see what the results look like.