Problem with Lookup

debasisp · Post by **debasisp** » Mon Mar 24, 2008 4:33 am

Hi,
I have a input dataset with one field "Id" as key. I am doing a lookup using a lookup stage with a DB2 table based upon "Id". But I am getting the following error ...

lookupstage: Error when checking operator: Key field "Id" not found in input schema

But if I perform lookup with anyother field in the dataset I am not getting any error.

Please help me out .

Cheers
Debasis

Nripendra Chand · Post by **Nripendra Chand** » Mon Mar 24, 2008 5:11 am

check the input dataset schema by viewing it through dataset management to check whether "Id" field really exist.

debasisp · Post by **debasisp** » Mon Mar 24, 2008 9:49 am

Hi Nri,
I have checked that .. Id is present in the dataset schema..
I also deleted and recreated the dataset but no luck.

Cheers
Debasis

ArndW · Post by **ArndW** » Mon Mar 24, 2008 10:15 am

If it is present in the dataset schema then you are left with the link coming from DB2. That is supported by the error message noting the "key" field is missing.

debasisp · Post by **debasisp** » Mon Mar 24, 2008 10:57 am

ArndW wrote:If it is present in the dataset schema then you are left with the link coming from DB2. That is supported by the error message noting the "key" field is missing. ...

Hi,
Can you please tell me how to get rid of this error. I checked the dataset schema and also removed and recreated the lookup link. But no luck..

Cheers
Debasis

ArndW · Post by **ArndW** » Mon Mar 24, 2008 11:53 am

Are you doing a sparse lookup or a normal one?

debasisp · Post by **debasisp** » Mon Mar 24, 2008 6:29 pm

Normal lookup

DSDexter · Post by **DSDexter** » Mon Mar 24, 2008 10:59 pm

Debasis,

Are the column names of the field you are defining as key same in both input link and reference link?

If so, Try renaming the either of the key field and then perform a lookup. e.g you could mention the reference column name as Id1 by writing a userdefined sql.

Try this and let us know whether it worked.

ArndW · Post by **ArndW** » Tue Mar 25, 2008 2:09 am

With a normal lookup the lookup stage will have a link from a column in the top left to a column marked as "key" in the bottom left. Are both those columns called "Id" in your job? What happens if you change the column name of at least one of them as suggested above?

debasisp · Post by **debasisp** » Tue Mar 25, 2008 3:59 am

DSDexter wrote:Debasis,

Are the column names of the field you are defining as key same in both input link and reference link?

If so, Try renaming the either of the key field and then perform a lookup. e.g you could mention the reference column name as Id1 by writing a userdefined sql.

Try this and let us know whether it worked.

Hi,
the column names are different .. But when i changed the lookup to sparse it is working fine.. Although this is a workaround and can be done in this way but still the question is open that why it is not working in normal lookup.

Thanks to all who joined this discussion . If any one of us find this solution please post it.

Cheers
Debasis

rajasingam · Post by **rajasingam** » Thu Mar 27, 2008 12:05 am

How to change normal Lookup to Sparse Lookup?

ray.wurlod · Post by **ray.wurlod** » Thu Mar 27, 2008 12:39 am

This is not the original problem. Please start a new thread.

We frown upon hijacking others' threads.