'/' in column name?

[#1]

Hello Guys,

I am stuck in a scenario,where column name of my sql table is like 'temp/test' and I am qlikview showing showing error that "temp field in not found" on reload.How we can handle this situation in load.Thanks in advance.

[MK_QSL]

SELECT REPLACE('temp/test','/','-');

[hic · Accepted solution]

You need to quote the field names, either with [ ] or with " " .

SQL SELECT [temp/test] FROM ...

SQL SELECT "temp/test" FROM ...

HIC

[#4]

Thank you guys.