Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Luminary
Luminary

Question about Reisdent load

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>

15 Replies
Luminary
Luminary

Re: Question about Reisdent load

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

thomas_skariah
Contributor III

Re: Question about Reisdent load

Hi Shilpan,

Can you please specify the error.

Regards,

Tom

Luminary
Luminary

Re: Question about Reisdent load

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
Contributor III

Re: Question about Reisdent load

Hi Shilpan,

Try to reload it by removing the where condition.

Regards,

Tom

Not applicable

Re: Question about Reisdent load

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..

Luminary
Luminary

Re: Question about Reisdent load

Tom,

It didn't work after removing the where condition.

thomas_skariah
Contributor III

Re: Question about Reisdent load

Hi,

If possible please frwd your application.

Regards,

Tom

Luminary
Luminary

Re: Question about Reisdent load

I tried by adding

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

Luminary
Luminary

Re: Question about Reisdent load

Tom,

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

Community Browser