Hi
I am working on Lookup File Set Stage, in doing so i am facing a problem.
When i am trying to make a lookup on key column a error msg is populatting like
Key expression cannot be set on key columns of this link.The connected stege defines the key lookup
Can i know the problem?
Lookup File Set Stage
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
The Lookup stage (on which you received this message) is being serviced by a reference input link on the other end of which is a Lookup File Set stage.
When the Lookup File Set stage was populated, its key was defined.
You are "locked in" to using this key - the Lookup stage will not let you attempt anything that might vary it. Hence the message you received.
You must match the key column name(s) and data type(s) on the stream input to the Lookup stage. If you have a mismatch, insert a Copy stage upstream of the Lookup stage to effect the name change.
The Lookup stage (on which you received this message) is being serviced by a reference input link on the other end of which is a Lookup File Set stage.
When the Lookup File Set stage was populated, its key was defined.
You are "locked in" to using this key - the Lookup stage will not let you attempt anything that might vary it. Hence the message you received.
You must match the key column name(s) and data type(s) on the stream input to the Lookup stage. If you have a mismatch, insert a Copy stage upstream of the Lookup stage to effect the name change.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.