Optimize Data

[sat_tok52]

Hi  Guru's,

I am loading below table in qlikview have 20M records , when i am doing reload the below table it's taking more time to reload.

How to optimize below tables load time.

TemP:

LOAD Date,

     product_group

FROM

(ooxml, embedded labels, table is Sheet1);

Left join(TemP)

LOAD product_group,

     bucket

FROM

(ooxml, embedded labels, table is Sheet1);

Thanks,

Sateesh.T

[Chanty4u]

can u shre ur excel?

[PrashantSangle]

Hi,

Looks like there is issue in your joining field.

Provide xls sheet to understand issue.

Regards,

[Chanty4u]

otherwise chk here

Optimised Load with Where

[jagan]

Hi,

Instead of join use Mapping Load and ApplyMap() like below if they are one-to-one.

Product_Group_Mapping:

MAPPING LOAD product_group,

     bucket

FROM

(ooxml, embedded labels, table is Sheet1)

WHERE 1 = 1;

TemP:

LOAD Date,

     product_group,

ApplyMap('Product_Group_Mapping', product_group, 'N/A') AS bucket

FROM

(ooxml, embedded labels, table is Sheet1);

Hope this helps you.

Regards,

Jagan.

[Anonymous]

Hi,

I do not know how many times you need to reload but I would suggest that load that data into QVD files and then load the main app from the QVD files. QVD files should reload faster but this all depends on how often the excel file is updated

[mightyqlikers]

hi,

you can also do like

TemP:

LOAD Date,

     product_group

FROM

(ooxml, embedded labels, table is Sheet1);

Left join(TemP)

LOAD product_group,

     bucket

FROM

(ooxml, embedded labels, table is Sheet1)

where exists(product_group);

Regards

$@M

[sat_tok52]

Hi Jagan,

Thanks for your response.

But it is not giving my expect result.

Thanks,

Sateesh