Discussion Board for collaboration on QlikView Scripting.
Hi to all!
Can some one tell me why distinct is inherited from previos load in join?
See the attachment. I am loading first table distinct and then loading second table NOT distinct and joining them. The result table turns out distinct too. Why?
Solved! Go to Solution.
Yes. In test 1 dublicate rows are dropped and i dont understand why.
Test 1 is with distinct load in first table and the second is without.
But the data is the same in both cases.
This is because your join resultant table is Groups1 which is qualified by DISTINCT before load. Therefore the table is loaded as distinct.
See the attached file, if you take a resident of the Groups1 table and then JOIN, you would get different result, because your resultant table is not qualified by DISTINCT there.