Question about Reisdent load

[shilpan]

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>

[thomas_skariah]

Hi Shilpan,

Yes,use the allias name during the resident load.

Please try the following

Comment the entire resident load and then reload.

     Check whether the error is still occuring.

Regards,

Tom

[thomas_skariah]

If possible try to frwrd an similar sample input file, then i can check from my side.

Regards,

Tom

[shilpan]

Tom,

I tried to attach the excel input file, but I can't do that if I am simply replying. Is there a way that I can send you?

[#5]

Hi,

PFA for your issue.. still if you are not getting then post sample application

[shilpan]

It worked. What I had to do was to rename original table from Employees to Employee

and then refer that to the resident load statement. I am still not sure as to why it worked after changing just table name?

[#7]

Hi

I think it is some spelling problem (capital or small letters)

it works for any name