How to change table names?

[Anonymous]

Hi,

i added excel tables. After that the names of the tables are like "table 1". Can i change the name?

Regrads,

F. Walter

[tahirkhalil]

Hi,

You can define your own name like:

Directory;

[MySampleTableName]:

LOAD S.no.,

     REGION,

     [Volume (LY) 2014],

     [Volume (CY)2015],

FROM

Test.xlsx

(ooxml, embedded labels, table is Sheet1);

The the following table will be referred as MySampleTableName.

[Anonymous]

Yes, Put a label which is alias for table like this?

TableName:

Load

*

From YourExcel;

[jonathandienst]

Or rename in the script using:

RENAME Table [table 1] to a2;

[Anonymous]

Hi,

thank you. Where must i put this script in? In "Main"?

[reddy-s]

Hi Fritz,

You just need to add this syntax before the load statement:

[Table name]:

[reddy-s]

Hi Fritz,

Yes add the code after the SET varaibles and will work fine.

[Anonymous]

You can use main tab or add another tab as well, Up to you

[Anonymous]

But why is the name correct, if i load this tables? This table is from the tutorial https://help.qlik.com/sense/1.1/de-DE/tutorials/Tutorial%20%E2%80%93%20Erstellen%20einer%20App.zip

I can´t find differences to my tables.

[Anonymous · Accepted solution]

I have found the solution. The name of the spreadsheet is the tablename in qliksense.

Regards,

Fritz