Another Map Question

Hello all,

What I'm doing involves looping. Don't panic, it's not that complicated – I just like detailed explanations. I have a flat

file schema (based on comma delinted repeating records, all of the same type)

Input: LegacyID1,Legacy1,LegacyID2,Legacy2,LegacyID3,Legacy3

These fields present themselves in pairs. LegacyID1 is a type code, and Legacy1 is a corresponding value. LegacyID1 won't exist without Legacy1, AND vice versa. The same thing goes for the LegacyID2/Legacy2 pair and the LegacyID3/Legacy3 pairs.

Pairs 2 and 3 are optional. For example, the input record could look like one of the following:

1C,334058,1C,W22192,1D,769475
or
1C,334012,1D,476600,,,
or
1D,1618735,,,,

What I need to do is loop through the input (a flat file schema) and make a repeating group of <Repeated> nodes that look

like this:

<Repeated>
 <PIDNumbers LID="1C" PValue="334058" />
</Repeated>

<Repeated>
 <PIDNumbers LID="1C" PValue="W22192" />
</Repeated>

<Repeated>
<PIDNumbers LID="1D" PValue="769475" />
</Repeated>

or

<Repeated>
 <PIDNumbers LIDr="1C" PValue="334012" />
</Repeated>

<Repeated>
 <PIDNumbers LID="1D" PValuer="476600" />
</Repeated>

or

<Repeated>
 <PIDNumbers LID="1D" PValue="1618735" />
</Repeated>

respectively.

I have no problem writing the loop which creates the correct number of <Repeated> nodes based on the number of LIDs in the input file. I just created a loop on LegacyID1,LegacyID2,LegacyID3 and added conditions on LegacyID2,LegacyID3 checking for length > 0. I can also correctly populated the LID values (by linking all three on the left to my destination attribute on the right). The problem I'm having is correctly populating Legacy1, Legacy2, and Legacy3. If I just do the same thing I did with LegacyID1,LegacyID2,LegacyID3 and link Legacy1,Legacy2,Legacy3 to my other destination attribute on the right, it just takes the last one (even when it is blank on the left). In the first example above, all three PValues come out as 769475, but everything else it correct. Not what I want. What I need is to have Legacy1 go along with LegacyID1, and, IF AND ONLY IF LegacyID2 exists, create another <Repeated> node, and populate  it with LegacyID2 and Legacy2 attributes. Same goes for the third.

Any help would be greatly appreciated.

Thanks