Reloading qvw takes long time after the script

[bharani8]

Hi Experts - Hope this will be simple to answer for you!!

Am new to this qlikview.. I have loaded around 23 .xls files in the script and later when i try to save & reload.. my system gets hung and doesnt respond. Please can you hel me out where am i going wrong?? Attached qvw is FYR...

[dineshm030]

Hi Bharani,

First you have to convert the xls files to QVD format. Then reload the QVW it will be faster than xls file.

Below is for your reference:

SalesJan:

LOAD Transaction_date,

     Product,

     Price,

     Payment_Type,

     Name,

     City,

     State,

     Country,

     Account_Created,

     Last_Login,

     Latitude,

     Longitude

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

STORE SalesJan into G:\QV\SalesJan.qvd (qvd);

SYNTAX:

STORE TABLE_NAME INTO (YOUR PATH);

Then you have to upload that QVD files likw xls files.

Regards,

Dinesh Kumar M

[Anonymous]

First follow Dinesh suggestion and then you need check how much RAM you have in your PC. for example if you are trying to open a 300MB QVW file with 4 GB RAM it will be tough for you.

[krishnacbe]

Hi,

The join should have only one Key. Your Join will create Synthetic Key and there are lot of Synthetic key so the QVD gets hung.

If you have same column name in each excel just concatenate them.

[bharani8]

But i have more excel files and in each file there are many columns that have same name.. Any other best solution??

[dineshm030 · Accepted solution]

Hi Bharani,

1st u have to convert all XLS files to QVD files by above the STORE syntax.

If u want to join the all tables using more than one columns, u can use QUALIFY and UNQUALIFY functions...

Regards,

Dinesh Kumar M

[krishnacbe]

Hi,

Instead of Join, try with Concatenate option.

[bharani8]

Thank you Dinesh!! Now am able to Reload all those 23 files!!

One more quick clarrification... I do see in the front end for each and every table as TableName.FieldName as we used Qulaify function... Is there any easy way so that all the fields in the front end appear without TableName as prefix ?? Because i do have 700+ fields in those 23 tables... or else i could have changed the name in the "Label box" in their respective object properties. Please Suggest..