Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
it's working with the [ ].
Thank you so much !!