Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You need to quote the field names, either with [ ] or with " " .
SQL SELECT [temp/test] FROM ...
SQL SELECT "temp/test" FROM ...
HIC
SELECT REPLACE('temp/test','/','-');
You need to quote the field names, either with [ ] or with " " .
SQL SELECT [temp/test] FROM ...
SQL SELECT "temp/test" FROM ...
HIC
Thank you guys.