topic Re: Table Not found error in QlikView

Table Not found error

Wed, 31 Oct 2012 17:51:07 GMT

Hello Team member

When I am converting my table into qvd I am getting the Table not Found error,Eventhough I gave the table name while converting into qvd using store,can anyone correct me

below is my script

LOAD ProductID,

OrderDate

FROM

E:\Qlikview\RichardBooks\BuildyourFirstApp\ProductOrderdate.xls

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

STORE ProductOrderdate into E:\Qlikview\RichardBooks\BuildyourFirstApp\ProductOrderdate.qvd;

Re: Table Not found error

MayilVahanan — Wed, 31 Oct 2012 17:54:08 GMT

Try like this

ProductOrderdate:

LOAD ProductID,

OrderDate

FROM

E:\Qlikview\RichardBooks\BuildyourFirstApp\ProductOrderdate.xls

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

STORE ProductOrderdate into E:\Qlikview\RichardBooks\BuildyourFirstApp\ProductOrderdate.qvd;

Re: Table Not found error

CELAMBARASAN — Wed, 31 Oct 2012 18:37:25 GMT

Hi,

You should mention the name for the table other wise table will asign random names by itself.

You can check the name of the table in table view.

Hope Mayil Suggesstion described you how to set the table name.

Re: Table Not found error

Wed, 31 Oct 2012 23:01:19 GMT

Thankq Adimulam

Re: Table Not found error

Wed, 31 Oct 2012 23:02:07 GMT

Thanks Ramamsamy .