Hi,
Can we have multiple reference look ups where lookup1 result can be used in look up2 in the same transformer?
i.e result of look up1 is the key for lookup2
Thanks,
Lookup inter dependency
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
No, you will need to use 2 transformers to do this.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
No, not a 'bug' per se, more of a limitation of the GUI. This has been debated here in the past, some people will happily do what you did and others won't. In any case, it does work - at least up through through the 7.5.x version, but can't say if it will keep on working in future versions.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Charter Member
- Posts: 166
- Joined: Wed Mar 16, 2005 6:52 am
- Location: Mumbai, India
I have noticed the same thing. Designer does not seem to like this( I always get an angry red font) but the code does work.
Must be something to do with the fact that the Transformer already has evaluated the all columns for Lookup1 and has the corresponding data from the reference data source before it starts evaluating Lookup2.
Must be something to do with the fact that the Transformer already has evaluated the all columns for Lookup1 and has the corresponding data from the reference data source before it starts evaluating Lookup2.
Amey Vaidya<i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>