lookup duplicates
Moderators: chulett, rschirm, roy
lookup duplicates
Lookup is distinct combination of key1 and key2. Now key1 and key2 both gets match from same reference dataset and same column.
key1 data has no duplicates but key2 has duplicates. now when look is performed every time getting different record count as output.
reference data has no duplicates.
how to get correct output
key1 data has no duplicates but key2 has duplicates. now when look is performed every time getting different record count as output.
reference data has no duplicates.
how to get correct output
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please confirm that your job design looks like this:
Code: Select all
+-------+
| |
| Ref. |
| |
+---+---+
|
V
+-------+
| |
| Copy |
| |
+-+---+-+
| |
ref1 | | ref2
V V
+-------+
| |
------> |Lookup | ------->
stream | |
+-------+
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: