2 Replies Latest reply: May 21, 2012 5:17 AM by Gaurav Malhotra RSS

    How to load Fields like Customers.CompanyName ???

    Gaurav Malhotra

      Invoices:

      LOAD ShipName,

          ShipAddress,

          ShipCity,

          ShipRegion,

          ShipPostalCode,

          ShipCountry,

          CustomerID,

          Customers.CompanyName,

          Salesperson,

          OrderID,

          OrderDate,

          Year(OrderDate) as Year,

          Month(OrderDate) as Month,

          Week(OrderDate) as Week,

          Day(OrderDate) as Day,

          'Q' & Ceil((Month(Addmonths(OrderDate,-3))/3)) as Quarter,

          RequiredDate,

          ShippedDate,

          Shippers.CompanyName,

          ProductID,

          UnitPrice,

          Quantity,

          Discount,

          ExtendedPrice,

          (UnitPrice*Quantity) as GrossRevenue,

          ((UnitPrice*Quantity) - ((UnitPrice*Quantity)*Discount)) as NetRevenue,

          Freight;

      SQL SELECT *

      FROM `D:\Test\Session 01\Data Sources\Nwind.mdb`.Invoices;

       

      This table is taken from the popularly available NorthWind.mdb data source.

       

      When i try to load these kind of fields. It giives me an error.

       

      Capture.JPG