excel file store in qvd

[#1]

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!!!

[Anonymous]

Try this.

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

[alexandros17 · Accepted solution]

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

[Anonymous]

Or

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];

[#5]

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];

[danielact]

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.

[Anonymous]

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

       or

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]; 

[its_anandrjs]

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

[#9]

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)];