Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
markgraham123
Specialist
Specialist
‎2019-10-31 12:00 PM

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)
Labels
Preview file
14 KB
521 Views
0 Likes
1 Reply
kswindlehurst
Contributor III
Contributor III
‎2019-10-31 01:18 PM

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.

503 Views