Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm performing association between 2 tables.
Table 1 has 10001 rows.
Table 2 has 9 rows (3 of them can be associated with Table 1).
After association, the Table Box (left) with 1 less field is showing 10007 rows which is correct.
But the Table Box (right) with all the fields only show 10001 rows.
May I ask why is the Table Box (right) only showing 10001 rows?
This only happens when Table 1 is more than 10000 rows.
Thanks.
Hi Goodafternoon;
First: Never Use Table Box to compare the result of the LOAD information because when you add the dimentions in a Table Box IF you have repeated rows the table box interpret like a DISTINCT and only will put one row for repited records. For This You have to use a STRAIGHT TABLES.
Now in response to your question is because QlikView interpret the load like a JOIN and how does work a Join?
This means that if multiple columns are shared between tables, the match will be made over the distinct
combinations of those columns.
try this with a LEFT JOIN
Check the image .
Best Regards!!!