6 Replies Latest reply: Oct 17, 2016 5:52 PM by Haikuo Yu RSS

    Load and Select data from database problem in Qlik Sense

    Haikuo Yu

      When I use the following query to load data from database to Qlik sense, Qlik Sense would complain 'no myDate field found'. Could you please give any suggestion? Thanks!

      I have connected to the database, and the connection is correct. I can not just use 'Load *, because I would like to some Qlik Sense function during loading data, such as 'GeoMakePoint ', 'Date()'.


      Load

           myDate ,

          date_String ,

           myVlaue ,

           latitude ,

           longititude ,

           GeoMakePoint ( latitude , longititude ) as myLocation

      Select

           TO_DATE(from_unixtime(UNIX_TIMESTAMP(date_String , 'M/dd/yyyy'))) as myDate ,

           date_String ,

           myVlaue ,

           latitude ,

           longititude

      From myTable