topic Re: table not found in QlikView

table not found

Mon, 24 Jun 2013 12:12:22 GMT

In the following request (of which I have created more than 100 like it) I am getting a Table Not Found error.

I cannot understand this due to having done so many others without issue and not getting the error. My understanding is that the table gets created by this very code. I have however created a blank qvd file, to see if this works, it didnt.

Any ideas?

// Load Purchase Orders

PurchOrders:

LOAD

PURCHID as [POrder_PURCHID],

PURCHNAME as [POrder_PURCHNAME],

ORDERACCOUNT as [POrder_ORDERACCOUNT],

WINDOWSID as [POrder_WINDOWSID];


SQL SELECT

    PURCHID,

    PURCHNAME,

    ORDERACCOUNT,

    WINDOWSID


FROM SELSQLAX.DynAxLive.dbo.PURCHTABLE;

store PurchOrders into \\sel-app-03\QlikView\Synseal\data\PurchOrders.qvd;

Drop Table PurchOrders;

Re: table not found

Mon, 24 Jun 2013 13:20:42 GMT

Have you tried this SQL sentence from Managemet Studio (with the same user)? This error usually occurs when there is no records in the table.

Re: table not found

Mon, 24 Jun 2013 13:40:00 GMT

try this

PurchOrders:

LOAD

PURCHID as [POrder_PURCHID],

PURCHNAME as [POrder_PURCHNAME],

ORDERACCOUNT as [POrder_ORDERACCOUNT],

WINDOWSID as [POrder_WINDOWSID];


SQL SELECT

    PURCHID,

    PURCHNAME,

    ORDERACCOUNT,

    WINDOWSID


FROM SELSQLAX.DynAxLive.dbo.PURCHTABLE;

store PurchOrders into 😧\PurchOrders.qvd;

Drop Table PurchOrders;

Re: table not found

Mon, 24 Jun 2013 14:01:47 GMT

Thanks for your ideas troups. I have just copied and pasted this and dumped it into a new file and it worked straight away.

Bizarre. Maybe a bug. Who knows.