Change table name

[#1]

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

     A,

     B,

     C,

     D

FROM

Downloads\test.xls

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

// Fullmetalboy

[its_anandrjs]

Hi,

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

YourTableName:   <--Your table name goes here.

LOAD

     A,

     B,

     C,

     D

FROM

Downloads\test.xls

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

Rgds

Anand

[#3]

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

[SunilChauhan]

hope this one you required

Directory;

LOAD

     A,

     B,

     C,

     D

FROM

Downloads\test.xls

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

Rename table Sheet1 to yourtablename ;

[its_anandrjs]

Hi,

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

Rgds

Anand

[kamalqlik]

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

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

or

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

LOAD

     A,

     B,

     C,

     D

FROM

Downloads\test.xls

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

hope this will help you

[hopkinsc]

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

     A,

     B,

     C,

     D

FROM

Downloads\test.xls

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