topic Re: excel file store in qvd in QlikView

excel file store in qvd

Wed, 18 Jun 2014 13:15:42 GMT

my problem is to store the excel file in qvd format

Let vDate= Today();

Directory;

LOAD Client,

Delivery,

Item,

[Item category],

[Created by],

Time,

[Created on],

Material,

[Material entered],

[Material Group],

Plant,

[Storage Location],

Batch,

[Vendor Batch],

[Customer material number],

[Product hierarchy],

[Delivery quantity]

FROM

LIPS_20140616.xls

(biff, embedded labels, table is [Sheet1$]);

Store LIPS_20140616 into [Testqvd_$(vDate).qvd]; whats wrong here table not found!!!

Re: excel file store in qvd

Anonymous — Wed, 18 Jun 2014 13:16:39 GMT

Try this.

Store Directory into [Testqvd_$(vDate).qvd];

Re: excel file store in qvd

alexandros17 — Wed, 18 Jun 2014 13:17:40 GMT

Write this:

Let vDate= Today();

LIPS_20140616:

LOAD Client,

Delivery,

Item,

[Item category],

[Created by],

Time,

[Created on],

Material,

[Material entered],

[Material Group],

Plant,

[Storage Location],

Batch,

[Vendor Batch],

[Customer material number],

[Product hierarchy],

[Delivery quantity]

FROM

LIPS_20140616.xls

(biff, embedded labels, table is [Sheet1$]);

Store LIPS_20140616 into [Testqvd_$(vDate).qvd];

just add LIPS_20140616 as alias of your table

let me know

Re: excel file store in qvd

Anonymous — Wed, 18 Jun 2014 13:17:55 GMT

Directory;

Products:

LOAD Client,

Delivery,

Item,

[Item category],

[Created by],

Time,

[Created on],

Material,

[Material entered],

[Material Group],

Plant,

[Storage Location],

Batch,

[Vendor Batch],

[Customer material number],

[Product hierarchy],

[Delivery quantity]

FROM

LIPS_20140616.xls

(biff, embedded labels, table is [Sheet1$]);

Store Products into [Testqvd_$(vDate).qvd];

Re: excel file store in qvd

Wed, 18 Jun 2014 13:19:04 GMT

Directory:

LOAD Client,

Delivery,

Item,

[Item category],

[Created by],

Time,

[Created on],

Material,

[Material entered],

[Material Group],

Plant,

[Storage Location],

Batch,

[Vendor Batch],

[Customer material number],

[Product hierarchy],

[Delivery quantity]

FROM

LIPS_20140616.xls

(biff, embedded labels, table is [Sheet1$]);

Store Directory into [Testqvd_$(vDate).qvd];

Re: excel file store in qvd

danielact — Wed, 18 Jun 2014 13:25:15 GMT

It doesn't use the name of your Excel file for the table by default, it uses the name of the sheet. In this case, your sheet is named Sheet1, so that's what your table will be called. To check this, just load the table without trying to store it, then see what name it has in QlikView.

Re: excel file store in qvd

Anonymous — Wed, 18 Jun 2014 13:25:25 GMT

Hi ,

In the below code, It is showing error because 'LIPS_20140616' it is not able to find this table.

Either u need to rename the table to some other name and use that name in the store statement

use 'Directory' in the store statement instead of 'LIPS_20140616'

Directory;

LOAD Client,

Delivery,

Item,

[Item category],

[Created by],

Time,

[Created on],

Material,

[Material entered],

[Material Group],

Plant,

[Storage Location],

Batch,

[Vendor Batch],

[Customer material number],

[Product hierarchy],

[Delivery quantity]

FROM

LIPS_20140616.xls

(biff, embedded labels, table is [Sheet1$]);

Store LIPS_20140616 into [Testqvd_$(vDate).qvd];

Re: excel file store in qvd

its_anandrjs — Wed, 18 Jun 2014 13:30:12 GMT

Try to load your table like below load script

Let vDate= Today();

'LIPS_$(vDate)': //Add LIPS_ waord with the variable vDate and use it as name and use this name to store your table with this name

LOAD Client,

Delivery,

Item,

[Item category],

[Created by],

Time,

[Created on],

Material,

[Material entered],

[Material Group],

Plant,

[Storage Location],

Batch,

[Vendor Batch],

[Customer material number],

[Product hierarchy],

[Delivery quantity]

FROM

LIPS_20140616.xls

(biff, embedded labels, table is [Sheet1$]);

Store 'LIPS_$(vDate)' into [Testqvd_$(vDate).qvd];

Hope This Helps

Re: excel file store in qvd

Wed, 18 Jun 2014 13:36:55 GMT

Hello Andreas,

Hope this helps

LIPS_20140616:

LOAD Client,

Delivery,

Item,

[Item category],

[Created by],

Time,

[Created on],

Material,

[Material entered],

[Material Group],

Plant,

[Storage Location],

Batch,

[Vendor Batch],

[Customer material number],

[Product hierarchy],

[Delivery quantity]

FROM

LIPS_20140616.xls

(biff, embedded labels, table is [Sheet1$]);

Store * from LIPS_20140616 into [Testqvd_$(vDate).qvd (qvd)];