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>

[shilpan]

Sorry for misspelling word 'Resident' in the title; my bad.

[thomas_skariah]

Hi Shilpan,

Can you please specify the error.

Regards,

Tom

[shilpan]

Hi Tom,

This is what I see:

Field not found - <Name>
SalesPersons:
LOAD 
EmployeeID,
Name as SalesPerson,
 
Title as SalesTitle
Resident Employees

Where Exists(EmployeeSalesID, EmployeeID)

[thomas_skariah]

Hi Shilpan,

Try to reload it by removing the where condition.

Regards,

Tom

[#6]

Hi,

Add one more field to the resident load.. like

SalesPersons:

LOAD 

EmployeeID,

Name as SalesPerson,

Title as SalesTitle,

1 as junk

Resident Employees 

Where Exists(EmployeeSalesID, EmployeeID);

later if you want you can drop the junk field..

[shilpan]

Tom,

It didn't work after removing the where condition.

[thomas_skariah]

Hi,

If possible please frwd your application.

Regards,

Tom

[shilpan]

I tried by adding

1 as junk. It didn't work. What is the logic behind adding this?

[shilpan]

Tom,

If original table(Employees) has an alias(Name),  can you use alias as the source column to refer to during the resident load?