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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Silvia2
Contributor II
Contributor II

Left Join

Hi!

I have a problem.

When I load 2 tables  DB and perform a left join the result contains 1800000+ records.

But, if I save those 2 tables in QVD files and then load from .qvd and perform the same left join the result contains 1900000+ records.

Why is this happening?

Thank you!

1 Reply
vinieme12
Champion III
Champion III

This is only possible when your join FIELDS  AND/ OR  conditions  done in db  and qlik are INCONSISTENT

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.