Originally posted by: repanzer1
Ok, first of all, now that I look at the picture, what you did was, you went to a group where there up to 9 allowed, R932_CHR_2_Group(0:9), you right clicked it and added an index, then you put the rule on that index. You are trying to extract multiple records into an index that can only contain 1, hence the big "1" right after the;
R932_CHR_2_Group[1]
You will only get one in your output, regardless of how many records are returned in the extract. Put the rule in the group with the (0:8), maybe it will work.
What I meant above that you asked about was, what you do is you add an output card to your map and make it the first one. For your example, your type tree for this card would be a file of records(s), and each record would contain the fields of the REF segment. In that output card, you do your extract, but you do not do the CHOOSE. So now when the map runs, the first output card contains the records you want for a field later on. When you get to the field you are trying to populate with the code you have above, you just do the choose against the output in the first output card;
=CHOOSE(Record:Outputcard1, 3).
I’m assuming that you know how to make “copies” of the output card so you can map from it, by putting your curser over the area where it says the card number and card name, holding down the left mouse click and dragging the curser off the card.
There are 10 types of people in this world. Those who understand binary and those who don't.
#IBM-Websphere-Transformation-Extender#DataExchange#IBMSterlingTransformationExtender