Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Anybody knows how to store all the below in one QVD
QVDLoad1:
LOAD *,
applymap('Manufact_Map', MANUFACTURERABBR,'Other' ) as ManufactLabel;
LOAD * from ..\QVD\ItemMaster.qvd(qvd);
Left Join(QVDLoad1)
Load * Inline [
MONTH,MonthName
1, Jul
2, Aug
3, Sep
4, Oct
5, Nov
6, Dec
7, Jan
8, Feb
9, Mar
10, Apr
11, May
12, Jun
];
LOAD *,
applymap('ManagerName_Map', MANAGER2, 'Other') as ManagerName;
LOAD *,
applymap('Department_Map', MANAGER2, 'Other') as Department;
LOAD *,
applymap('Division_Map', MANAGER2, 'Other') as Division;
LOAD * from ..\QVD\ShipItem.qvd(qvd);
LOAD * from ..\QVD\Putbom.qvd(qvd);
I tried Store QVDLoad1 into ByBrand.qvd(qvd);
but it didn't pick up everything
Hi again,
I tried that but it didnt help..
I left the Laoding from the qvds as it (loading from 3 different qvds)and added a name to the month map and used it the same way you have told me. then I uncommented the Eng tab on the script ..
I am still getting the same error..
See attached
Man, I have to submit this project tomorrow and don't know what to do!
I appreciate any possible help.
Thxs
Hi,
Attached the file.
This code should work now.
Regards
Andrew Hudson
Hey Andrew,
Thanks for your help.
I have treid the new code but it is not working.
It starts loading and freezes while loading then I get a failure to load message.
Is there anyway I can load all of this without Left join Qvd3 to QVD1?
Again thanks for spending the time helping me.
Regards,
Badr
Hi,
The script is failing because, the data is huge and doing the joins will take high amount of your RAM.
Just limit the no of rows to 10000 by adding where rowno()<10000 in every load.
Check whether it is storing the values in one qvd.
After that proceed with complete set of data.
Regards
Andrew Hudson
Hi Andrew,
If I do that then I won't get all the data!
while I need all of it
Regards,