2 Replies Latest reply: Mar 1, 2018 4:15 AM by Jamel Messaoud RSS

    Load Data

    Jamel Messaoud

      Hi guys,


      I have downloaded a sample Geo-Analytics file which calculates the mileage between two points



      LOAD * INLINE "




      " (delimiter is '|') ;


      The above load statement works brilliantly but my problem is that I would like to load the data from a QVD file


      I have tried to replicate the QVD load (like above) but this doesn't work




          vehicle as id,

          '[' & start_longitude & ',' & start_latitude & ']' as start,

          '[' & end_longitude & ',' & end_latitude & ']' as end


           QVD File (qvd)  


      Is it because the QVD file needs loading pipe delimited?  Not sure you can do this?


      What I am seeing when I load like this is the same distance calculated for two completely different routes which is obviously not correct.


      Perhaps I am going about this the wrong way?  I would appreciate any advice








        • Re: Load Data
          Patric Nordström

          Hi Jamel,

          Should work, try plotting start and end on the QGA map just to make sure the formatting works and the points are in the right place.


          Another option is to use GeoMakePoint(lat_field_name, long_field_name) which does the same thing




            • Re: Load Data
              Jamel Messaoud

              Hi Patric,


              Thanks for the reply.


              I have found the problem.  I was using a vehicle registration number as the ID column so in essence the ID was always the same for each row of data. I have used a unique ID now and it works!


              Thanks also for the tip regarding Geomakepoint that will save me some time/hassle