I have an lookup file file like below.
Not50,PLAN,HPHC
50,ANY,MEDICA
I have the following input file.
100,PLAN
50,100
Here is the description.
100 means Not50 in the lookup file that means it matched and PLAN matched with PLAN then it should return HPHC.
second row in the input file 50 matches with 50 in the lookupfile second row and 100 means ANY.so it should return MEDICA
Output:
100,PLAN,HPHC
50,100,MEDICA
Both are files only.So how can we acheive this in parallel job by using lookup file stage.Please give me suggestion to perform this lookup.
Thanks
Lookup logic
Moderators: chulett, rschirm, roy
Lookup logic
Last edited by dstest on Fri Aug 15, 2008 11:58 pm, edited 1 time in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Two lookups. The first looks up 50. The result of that goes through a Transformer stage that generates the string "Not50". The second lookup is conditional on the first having failed.
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: