15 Replies Latest reply: Jan 7, 2013 12:33 AM by Arya v RSS

    Question about Reisdent load

    Shilpan Patel

      I can't figure out why I am getting an error message during the reload.

       

      I have these two tables in my script.

       

       

      Employees:

      LOAD 

      Office&'-'&EmpID AS BudgetKey,

      EmpID AS EmployeeID,

      [First Name]&' '&[Last Name] AS Name,

      Title,

      [Hire Date],

      Year([Hire Date]) AS HireYear,

      Office,

      Extension,

      [Reports To],

      [Year Salary]

      FROM Datasources\Emp*.xls (biff, embedded labels, table is [Employee$]);

       

       

      SalesPersons:

      LOAD 

      EmployeeID,

        Name as SalesPerson,

      Title as SalesTitle

      Resident Employees

      Where Title like 'Sales*' or Title = 'President';

       

      I am getting this error during the reload :   Column not found <Name>