2 Replies Latest reply: Aug 12, 2013 12:33 PM by Carlos Duque RSS

    reload with $ symbol

    Carlos Duque

      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

          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