topic '/' in column name? in QlikView

'/' in column name?

Fri, 21 Feb 2014 11:43:49 GMT

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.

Re: '/' in column name?

MK_QSL — Fri, 21 Feb 2014 11:52:20 GMT

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

Re: '/' in column name?

hic — Fri, 21 Feb 2014 12:07:47 GMT

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

SQL SELECT [temp/test] FROM ...

SQL SELECT "temp/test" FROM ...

HIC

Re: '/' in column name?

Fri, 21 Feb 2014 14:14:50 GMT

Thank you guys.