topic Re: reload with $ symbol in QlikView

reload with $ symbol

easternfish — Mon, 12 Aug 2013 16:13:06 GMT

Hi,

I was wondering how I can inluded the $ symbol during my reload process. When I reload the same file using just the SQL option I get no errors and I'm able to use the "INV$" field in my Expressions with no problems but if i use the LOAD option I get an errror rightway from the reload proccess.

Any ideas on how I can use LOAD instead of SQL to retrived the data with $ sign fields from a database?

SQL SELECT *

FROM DATABASE.COMPANY WHERE COMP = 1;

LOAD

DATE,

Year (date(date#(SBINDT, 'YYYYMMDD'),'YYYY/MM/DD')) as Year,

INV$,

COMP,

STATE,

CITY;

SQL SELECT *

FROM DATABASE.COMPANY WHERE COMP = 1;

thank you

Re: reload with $ symbol

jaime_aguilar — Mon, 12 Aug 2013 16:21:14 GMT

I try to replicate this error, but I didn't get an error message when using $ in fieldnames. However, it's possible that QlikVIew is not interpreting the fieldname as expected.

You can try putting the fieldname between [ ], so QlikView interprets correctly the fieldname.

it would be something like:

LOAD

DATE,

Year (date(date#(SBINDT, 'YYYYMMDD'),'YYYY/MM/DD')) as Year,

INV$ as [INV$],

COMP,

STATE,

CITY;

SQL SELECT *

FROM DATABASE.COMPANY WHERE COMP = 1;

Regards

Re: reload with $ symbol

easternfish — Mon, 12 Aug 2013 16:33:15 GMT

it's working with the [ ].

Thank you so much !!