Hi All,
I am developing a new qlikview application and currently the application have nothing but only the follow code:
TABLE_1:
SQL SELCT
COLUMN_FOR_JOIN,'Y' as Col_A
From Table_I;
store TABLE_1 into [..\..\..\Data\TABLE_1.qvd];
join
LOAD Col C,
COLUMN_FOR_JOIN,
[Col B],
Col_D,
Col_E,
Col_F,
Col_G,
Col_H,
Col_I,
Col_J,
'Y' as COL_K
FROM
[..\..\..\Data\mydata.qvd]
(qvd);
I need to do an outer join between the two tables.
I have no problem on downloading data from the database or reading the mydata.qvd. However, after loading the data into Qlikview. Qlikivew was hung, (I assume that it was doing the join operation). But do you know how to make it work faster?
Both table have 8,000,000 - 10,000,000 rows. and the column_for_join from table_1 is a primary key while column_for_join from the QVD file is a key only (approx.90%) unique. column_for_join is not null for both table.
I am using Qlikview Personal Edition in a Windows 7 PC with 4GB RAM and i5 CPU. Does it because it ran out of resources? If so, can anyone give me a hint on how to due with it. This is because the application will be run in a weekly base and data is expected to growth in approx. 4000 rows daily.
Thanks in advance!
Kind Regards,
