Hi,
I have a qvw file which is renamed from original file.
Original Loader:e-loader
t-loader
Original file : Budget.qvw
Renamed Loader: e-loader_new
t-loader_new
Renamed file: Budget_new.qvw
Actually the Budget.qvw has data upto April and this file is reloading everyday but some changes in the database it is getting only one field data and remaining data is not populating so there is no data from April. That's the reason I took a copy of Budget.new and renamed as Budget_new.qvw and I made changes and all is fine. But since two days I am getting ALLOCATED MEMORY EXCEEDED when I try to open one straight table and it is incresing day by day Today I observed that staright table is not picking the data even in 2008-2009 year also. Actually I added one old table which is having data only upto April be cause I need one field which is having character data in OLD table and now this character data is changed to ID(integers) in NEW Table. I need to get a straight table which will show NEWID || OLDNAME side by side I did like that but now I am getting this problem.
Kindly Could anyone help me in this as it is effecting to entore file like a virus . I need to stop it. Please help.
This is the script which I used in one tab to consider OLD table field
Qualify *;
UNQUALIFY *;
TABLE_OLD:
LOAD Id,
name as name_11,
name_New_Oldtable,
IF(len(trim(name_New_Oldtable))=0 OR ISNULL(name_New_Oldtable)=-1,'Others',name_New_Oldtable) AS company
FROM
[..\QVD\QVDNEW\TQVD_new\T_xx.qvd]
(qvd);
