5 Replies Latest reply: May 4, 2016 12:01 AM by Ajay Gupta RSS

    Field Not found Error in Load Editor

    Ajay Gupta

      Hi,

      I am trying to load data but I get "Field Not Found Error"  for the third table ( GeoAggr1) . It complains for the group by column ( Column state not found). What am I doing wrong here ? If I replace state with Postcode, data gets loaded but I have to group at state level or at delivery_center level. I am attaching both the files too.

       

      Geo:

      LOAD

          "Australian Postcodes.Name" as Postcode,

          "Australian Postcodes.Point",

          "Australian Postcodes.Area"

      FROM [lib://AusPost/Australian Postcodes.kml]

      (kml, Table is [Australian Postcodes/Postcodes_Simplified]);

       

      Latlon:

      LOAD

          postcode as Postcode,

          suburb,

          state,

          dc as delivery_center,

          "type",

          lat,

          lon,

          CountryISOCode

      FROM [lib://AusPost/Australian_Post_Codes_Lat_Lon.csv]

      (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

       

      GeoAggr1:

      load     //'Combined' as Com,

      GeoAggrGeometry("Australian Postcodes.Area") as Combined

      resident Geo

      group by state;