chiefrocka1
Programmer
I'm having a looping issue with an 856. I need five pallets each with one item on them. However, my data comes out like below. The first pallet (HL*P) contains all the items and at then end are the rest of the pallets. Is this a query or key field issue on the input side of the map or does the output side need to be rearranged?
Map Input: ODBC
Map Output: X12
BSN*00*254001*20130103*1621~
DTM*011*20121119*1246~
HL*1**S*1~
MEA*PD*G*21993*LB~
TD5*B*2*LIGD~
N1*ST**92*12345~
N1*SF**92*67890~
[highlight #EDD400]HL*2*1*P*1~[/highlight]
REF*LA*241151181~
[highlight #73D216]HL*3*2*I*0~[/highlight]
LIN**VN*61423/4-08020~
SN1**500*19~
[highlight #73D216]HL*4*2*I*0~[/highlight]
LIN**VN*61423/4-08020~
SN1**500*19~
[highlight #73D216]HL*5*2*I*0~[/highlight]
LIN**VN*61423/4-08020~
SN1**500*19~
[highlight #73D216]HL*6*2*I*0~[/highlight]
LIN**VN*61423/4-08020~
SN1**500*19~
[highlight #73D216]HL*7*2*I*0~[/highlight]
LIN**VN*61423/4-08020~
SN1**500*19~
[highlight #EDD400]HL*8*1*P*1~[/highlight]
REF*LA*241151183~
[highlight #EDD400]HL*9*1*P*1~[/highlight]
REF*LA*241151186~
[highlight #EDD400]HL*10*1*P*1~[/highlight]
REF*LA*241151185~
[highlight #EDD400]HL*11*1*P*1~[/highlight]
REF*LA*241151184~
CTT*11~
Map Input: ODBC
Map Output: X12
BSN*00*254001*20130103*1621~
DTM*011*20121119*1246~
HL*1**S*1~
MEA*PD*G*21993*LB~
TD5*B*2*LIGD~
N1*ST**92*12345~
N1*SF**92*67890~
[highlight #EDD400]HL*2*1*P*1~[/highlight]
REF*LA*241151181~
[highlight #73D216]HL*3*2*I*0~[/highlight]
LIN**VN*61423/4-08020~
SN1**500*19~
[highlight #73D216]HL*4*2*I*0~[/highlight]
LIN**VN*61423/4-08020~
SN1**500*19~
[highlight #73D216]HL*5*2*I*0~[/highlight]
LIN**VN*61423/4-08020~
SN1**500*19~
[highlight #73D216]HL*6*2*I*0~[/highlight]
LIN**VN*61423/4-08020~
SN1**500*19~
[highlight #73D216]HL*7*2*I*0~[/highlight]
LIN**VN*61423/4-08020~
SN1**500*19~
[highlight #EDD400]HL*8*1*P*1~[/highlight]
REF*LA*241151183~
[highlight #EDD400]HL*9*1*P*1~[/highlight]
REF*LA*241151186~
[highlight #EDD400]HL*10*1*P*1~[/highlight]
REF*LA*241151185~
[highlight #EDD400]HL*11*1*P*1~[/highlight]
REF*LA*241151184~
CTT*11~