Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Store in a QVD

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

14 Replies
Not applicable
Author

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

adhudson
Creator II
Creator II

Hi,

     Attached the file.

     This code should work now.

Regards

Andrew Hudson

Not applicable
Author

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

adhudson
Creator II
Creator II

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

Not applicable
Author

Hi Andrew,

If I do that then I won't get all the data!

while I need all of it

Regards,