topic Change table name in QlikView

Change table name

Mon, 10 Oct 2011 08:50:08 GMT

I'm a newbie in Qlikview and need some help.

How do I change the name of the table so I don't need to see the name "Sheet1" in the table after completed reloading the script code?

The code is:

Directory;

LOAD

FROM

Downloads\test.xls

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

// Fullmetalboy

Change table name

its_anandrjs — Mon, 10 Oct 2011 08:53:46 GMT

Hi,

Give your choice table name in above the load code like see the code

YourTableName: <--Your table name goes here.

LOAD

FROM

Downloads\test.xls

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

Rgds

Anand

Change table name

Mon, 10 Oct 2011 08:55:15 GMT

Hi,

you con add the tablename before the LOAD. In your case:

tablename:

Directory;

LOAD

...

The tablename has to be one word, otherwise you have to use [name of table].

Regards

vicky

Change table name

SunilChauhan — Mon, 10 Oct 2011 09:09:24 GMT

hope this one you required

Directory;

LOAD

FROM

Downloads\test.xls

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

Rename table Sheet1 to yourtablename ;

Change table name

its_anandrjs — Mon, 10 Oct 2011 09:46:49 GMT

Hi,

Hope you got correct answer with this if so mark it correct or help ful so other can see it.

Rgds

Anand

Change table name

kamalqlik — Mon, 10 Oct 2011 10:23:58 GMT

Hi Jimmy....you can do like this....

TableName: (in case table name is of one word)

[Table Name] (in case you are using more than one word)

LOAD

FROM

Downloads\test.xls

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

hope this will help you

Change table name

hopkinsc — Mon, 10 Oct 2011 11:33:15 GMT

Hi, all you need to do is instead of using Directory; , use your table name but instead of the semi colon (;), use colon(:)

TableName:

LOAD

FROM

Downloads\test.xls

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