Hi,
We have a requirement where we require multiple matching rows from refernce data to be outputed out of a lookup. We are using Datastage Server Jobs. Can someone help us on how this can be achieved through Server Jobs
Eg:
Master File/table:
Id Name
1 A
2 A
3 B
5 C
6 C
7 C
8 C
9 C
Refernce File/Table
ID Feild1
1 A
2 A
3 B
5 C
6 C
7 C
8 C
9 C
X 1
Y 2
U X
V Y
Output expected:
ID Name Field1
1 A A
2 A A
X 1 A
Y 2 A
U X A
V Y A
Lookup table with multiple values as output!!
Moderators: chulett, rschirm, roy
I don't know if it is just me being tired, but I can't figure out your logic. Your source has 8 rows, reference has 13 and output 6. Your output key seems to come from the reference file, but the output makes it seems as if you are retrieving the "Feild1" <sic> value. Could you perhaps explain the logic or use unique column names to make it easier to understand the example?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: