topic Re: Question about Reisdent load in QlikView

Question about Reisdent load

shilpan — Mon, 07 Jan 2013 03:00:19 GMT

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>

Re: Question about Reisdent load

shilpan — Mon, 07 Jan 2013 03:08:08 GMT

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

Re: Question about Reisdent load

thomas_skariah — Mon, 07 Jan 2013 03:12:16 GMT

Hi Shilpan,

Can you please specify the error.

Regards,

Tom

Re: Question about Reisdent load

shilpan — Mon, 07 Jan 2013 03:24:55 GMT

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)

Re: Question about Reisdent load

thomas_skariah — Mon, 07 Jan 2013 03:33:37 GMT

Hi Shilpan,

Try to reload it by removing the where condition.

Regards,

Tom

Re: Question about Reisdent load

Mon, 07 Jan 2013 04:08:11 GMT

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

Re: Question about Reisdent load

shilpan — Mon, 07 Jan 2013 04:26:22 GMT

Tom,

It didn't work after removing the where condition.

Re: Question about Reisdent load

thomas_skariah — Mon, 07 Jan 2013 04:28:00 GMT

Hi,

If possible please frwd your application.

Regards,

Tom

Re: Question about Reisdent load

shilpan — Mon, 07 Jan 2013 04:28:13 GMT

I tried by adding

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

Re: Question about Reisdent load

shilpan — Mon, 07 Jan 2013 04:30:25 GMT

Tom,

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

Re: Question about Reisdent load

thomas_skariah — Mon, 07 Jan 2013 04:38:18 GMT

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

Re: Question about Reisdent load

thomas_skariah — Mon, 07 Jan 2013 04:40:26 GMT

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

Regards,

Tom

Re: Question about Reisdent load

shilpan — Mon, 07 Jan 2013 04:47:09 GMT

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?

Re: Question about Reisdent load

Mon, 07 Jan 2013 04:56:57 GMT

Hi,

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

Re: Question about Reisdent load

shilpan — Mon, 07 Jan 2013 05:09:43 GMT

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?

Re: Question about Reisdent load

Mon, 07 Jan 2013 05:33:24 GMT

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

it works for any name