Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

homersimpson
Contributor II

How to change table names?

Hi,

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

Regrads,

F. Walter

1 Solution

Accepted Solutions
homersimpson
Contributor II

Re: How to change table names?

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

screenshot_03.jpg

screenshot_02.jpg

Regards,

Fritz

10 Replies
tahirkhalil
New Contributor III

Re: How to change table names?

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.

balrajahlawat
Esteemed Contributor

Re: How to change table names?

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

TableName:

Load

*

From YourExcel;

MVP
MVP

Re: How to change table names?

Or rename in the script using:

RENAME Table [table 1] to a2;

homersimpson
Contributor II

Re: How to change table names?

Hi,

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

reddys310
Honored Contributor II

Re: How to change table names?

Hi Fritz,

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

[Table name]:

reddys310
Honored Contributor II

Re: How to change table names?

Hi Fritz,

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

balrajahlawat
Esteemed Contributor

Re: How to change table names?

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

homersimpson
Contributor II

Re: How to change table names?

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.

homersimpson
Contributor II

Re: How to change table names?

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

screenshot_03.jpg

screenshot_02.jpg

Regards,

Fritz