Skip to main content

Qlik

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: 
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

  • join

Preview file
14 KB
290 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.

272 Views