My hash file contains four fields with two keys.
If I link my primary table to hash file there multiple rows are returned .
In these rows i need to check third field of hash file and depend on it enter the fourh value from hash file to target table.
How I can do it ?
If hash file appropriate for this kind of logic within multiple rows?
Search Multiple Rows from Hash File
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Hi,
depending on the exact logic you could do this using multy value columns in a hash file or an ODBC stage defining a multy reference in the transformer stage's input link.
IHTH,
depending on the exact logic you could do this using multy value columns in a hash file or an ODBC stage defining a multy reference in the transformer stage's input link.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org