topic Re: Space_Error in QlikView

Space_Error

Tue, 12 Aug 2014 06:40:01 GMT

Hello Community,

I need a clarification on this

Table which contains field name and field-values(tables which are already exists in mdb) are respectively

Tablename and Orders,...,Odrer Details

My script was follows as like this

LOAD * INLINE [

Tablename

Orders

Customers

Products

Re: Space_Error

Anonymous — Tue, 12 Aug 2014 06:43:01 GMT

Not sure this is correct

use [Order Details]

Re: Space_Error

Tue, 12 Aug 2014 07:31:24 GMT

But we can't

Re: Space_Error

Miguel_Angel_Baeyens — Tue, 12 Aug 2014 07:34:10 GMT

Hi,

Use instead:

FROM '$(Vtable)';

Miguel

Re: Space_Error

Tue, 12 Aug 2014 08:41:47 GMT

No use.

Re: Space_Error

Miguel_Angel_Baeyens — Tue, 12 Aug 2014 08:53:53 GMT

I'm assuming that "Order Details" is a valid database table name, since you have not specified otherwise.

If you use your SQL Query tool, can you select from "Order Details" with space? In postgres, for example you need the character "`" (grave tilde) when the name of the table or field has something else than azAZ (underscores, points, etc).

Make sure that your data source (your MDB) has the table stored with space and that you can do the query manually.

I have created a sample test in my laptop and works fine.

Moreover, make sure that the loop is populating the variables as you expect.

Miguel

Re: Space_Error

Tue, 12 Aug 2014 09:36:16 GMT

Yes manually it was working fine.

But i want to retrieve the all the tables dynamically(which all are tables exists in MDB) irrespective of any space.

See below this is one more scenario for your reference.Creating QVD's through Binary load irrespective of any space.Here no issues it was working fine.

Binary d:\practice\workbook\bkp\qv_training.qvw;

SET Vbinqvdpath=D:\Others\Bin\;

Let Vbinumtab=NoOfTables();

FOR i=0 to $(Vbinumtab)

Let Vtable=TableName(i);

STORE [$(Vtable)] into $(Vbinqvdpath)[$(Vtable).qvd](qvd);

Regards,

Sattish G

Re: Re: Space_Error

Miguel_Angel_Baeyens — Tue, 12 Aug 2014 14:55:35 GMT

So I was right, the grave tilde works (see attached).

Miguel