Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can anyone help me?

Status
Not open for further replies.

TLBL

Programmer
Mar 20, 2008
8
US
I am trying to bring in a field in a record from a file into a functional map but it is not reading the file in when it gets to the functional map. I have 2 inputs and 1 output. I have tried everything possible I can think of. I have tried adding the field as another argument to bring it in through the functional map and that does not work. Anyone have any ideas?
 
if you pass NONE to a functional map, it will not be called. do you know if both values being passed to teh functional map and not NONE.
 
The values from my second input are being passed into the functional map. However the value from my first input is not. I am doing a LOOKUP using the first input which it is reading fine. The code I am using is below:

FM_Billing_Record3( Record:Group:In_Metavante, LOOKUP (Record:In_Metavante_Table , FILLLEFT(NUMBERTOTEXT( Division_ID Data:Record:In_Metavante_Table ), "0", 11) = Organizational_Unit_ID# Data:HI_Record<>Record:Group:In_Metavante) )

In the In_Metavante file I am trying to pass one of the fields from the record and it is not reading it in. I have tried several snipets of code including:

=FM_Billing_Record3( Record:Group:In_Metavante, LOOKUP (Record:In_Metavante_Table , FILLLEFT(NUMBERTOTEXT( Division_ID Data:Record:In_Metavante_Table ), "0", 11) = Organizational_Unit_ID# Data:HI_Record<>Record:Group:In_Metavante), Card_Open_Date Data:pA_Record<>Record:Group:In_Metavante)

Which should bring the date into the functional map but it is not. I had got to the point where I got caught in an cartesian product. Do you have any other ideas I can try?
 
See the answers on the IBM forum. If you attach the map with all the rules in I may be able to help. The last map didn't have anything mapped in the functional map.
Your basic problem is that your lookup doesn't work. Try getting that to work in an output card first then wory about your functional map.
 
I have tried and kept getting the Cartesian product occurences. However, I have a similar lookup that works which I have included in the map source as well. I made sure I mapped everything this time. I copied it from the entire map source and I was just trying to send the map I was having trouble with. Sorry...Thanks for any help or guidance.
 
I will also repost the zip file on the IBM site as well. You may not be able to get it from here.
 
For a functional map to be called, it needs all the inputs during run time. If one of your inputs are evaluating to none or it returns nothing,functional map will not be called. As janhes said, your lookup is the problem. Try to test your lookup rule seperately and see if it is returning values.
 
Thanks. The file in which the lookup is done is passing the correct data from that file. The other data I need in the output is coming from a second input file in which I do not have a lookup. I tried to add a second lookup for that file but I do not get any data when I run it.
 
You haven't posted the zip file on the IBM forum yet.
 
Hi TLBL,

Can you please send the exact rule where actual functional map is being called and also the details of the functional map like details input cards, no.of cards etc.

Thanks,
smerck
 
The lookup is below. I have 2 inputs and one output. Most of the data for the input is coming from the In_Metavante_Table file. I need one piece of data from the In_Metavante file which is the data I can not get into my output. The functional map is being called in the groups data section (File, Group(s), Record(s)) output structure.

FM_Billing_Record3( Record:Group:In_Metavante, LOOKUP (Record:In_Metavante_Table , FILLLEFT(NUMBERTOTEXT( Division_ID Data:Record:In_Metavante_Table ), "0", 11) = Organizational_Unit_ID# Data:HI_Record<>Record:Group:In_Metavante) )
 
Did you try testing your lookup seperately? I guess it is returning any values and hence your functional map is not being called.
 
Yes I have tried testing the lookup separately and saw the values it was returning. I wasn't returning any values for the second lookup or the second input file. I have created a work around for it that works. I just had to add 2 extra maps.
 
Your problem was due to partitioning of the records. Once this was removed the lookup worked ok.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top