
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
[QlikSense] Table Name Rule
Hi All.
I have a query regarding a table name.
For example :
a[TestName]:
Load * INLINE
[
a,b
1,2
];
Running this statement is resulting unknown error.
One thing for sure that the mistake is in the table name, because if i change the name into "a[TestName]" or [TestName] or TestName it will run.
The question is, Is there any table name rule regarding square bracket?
I'm using version June 2018. Previously i'm using June 2017.
Thanks,
Kevin
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Kevin,
You could check the realese notes of latest version of Qlik sense.
In theses documents you'll found "Bug Fixes" and "Known issues and limitations", it's posible that in new version a change was applied in table labels rules.
Regards


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Jose,
Based on the provided link, Labels containing blanks must be quoted using single or double quotation marks or square brackets.
So, my table name not contains any blanks or space. So i think this still count in the range of stated rule.
But, there is a square bracket in the middle of the string (which usually, be used in front and the back of the string according to the stated rule). As I can't change anything, because this is the format and working on June 2017 Version and i interested behind this Unknown Statement Error.
I think there should be a technical preview available regarding this?
Thanks,
Kevin


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
the square brackets with table name are needed when you have spaces between words ex. [Table 1].


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
what's your table name in June '17 data model for that table ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Andrea,
As this is the format i'm using previously NameMap[TableName], i need to write also the Square Brackets even though there is no space. This issue can be solved using "NameMap[TableName]", but i'm more interested to is there any rule regarding this bracket square, as in June 2017 it still working.
Thanks,
Kevin

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Andrea,
Should be no different from the example.
Let's say that the format for the Table Name is :
NameMap[TableName]
Thanks,
Kevin


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Kevin,
You could check the realese notes of latest version of Qlik sense.
In theses documents you'll found "Bug Fixes" and "Known issues and limitations", it's posible that in new version a change was applied in table labels rules.
Regards
