which gentran? my approach would be to output a flat or delimited file with a created sort key, and then sort the rows outside of the mapper. you could then run a 2nd mapping pass to reformat the data.
Becker, Adam wrote: > Hello Everybody, > > I'm trying to do a mapping in Gentran that is making my head hurt and I > was hoping someone could point me in the right direction. We receive an > 830 from Chrysler that goes kinda like this: > > LIN**BP*PARTNO1*PO*555~ > N1*ST**92*SHIPTO1~ > FST*100*D*W*070101~ > FST*100*D*W*070108~ > LIN**BP*PARTNO1*PO*555~ > N1*ST**92*SHIPTO2~ > FST*200*D*W*070101~ > FST*200*D*W*070108~ > LIN**BP*PARTNO2*PO*555~ > N1*ST**92*SHIPTO1~ > FST*100*D*W*070101~ > FST*100*D*W*070108~ > LIN**BP*PARTNO2*PO*555~ > N1*ST**92*SHIPTO2~ > FST*200*D*W*070101~ > FST*200*D*W*070108~ > LIN**BP*PARTNO1*PO*NA~ > FST*1200*D*M*070212~ > FST*1200*D*M*070312~ > LIN**BP*PARTNO2*PO*NA~ > FST*1200*D*M*070212~ > FST*1200*D*M*070312~ > > and we would like to combine the extended monthly forecasts without ship > tos for a given part number, with the immediate weekly forecasts with > ship tos for that part number, ex: > > LINE,PARTNO1 > ADDRESS,SHIPTO1 > QUANTITY,100,DISCREET,WEEKLY,070101 > QUANTITY,100,DISCREET,WEEKLY,070108 > QUANTITY,600,DISCREET,MONTHLY,070212 > QUANTITY,600,DISCREET,MONTHLY,070312 > LINE,PARTNO1 > ADDRESS,SHIPTO2 > QUANTITY,200,DISCREET,WEEKLY,070101 > QUANTITY,200,DISCREET,WEEKLY,070108 > QUANTITY,600,DISCREET,MONTHLY,070212 > QUANTITY,600,DISCREET,MONTHLY,070312 > LINE,PARTNO2 > ADDRESS,SHIPTO1 > QUANTITY,100,DISCREET,WEEKLY,070101 > QUANTITY,100,DISCREET,WEEKLY,070108 > QUANTITY,600,DISCREET,MONTHLY,070212 > QUANTITY,600,DISCREET,MONTHLY,070312 > LINE,PARTNO2 > ADDRESS,SHIPTO2 > QUANTITY,200,DISCREET,WEEKLY,070101 > QUANTITY,200,DISCREET,WEEKLY,070108 > QUANTITY,600,DISCREET,MONTHLY,070212 > QUANTITY,600,DISCREET,MONTHLY,070312 > > I've been able to get identical part numbers that appear in sequence in > the message to combine their requirements, but I don't seem to be a good > enough indexer to figure out how to go back up to the part numbers and > add in the extended monthly requirements after Gentran has already read > through different part numbers. > > Any pointers or thoughts will be very much appreciated! > Thanks! > Adam > > This email message and any attachments are for the sole use of the intended > recipient(s). This email and any attachments may contain confidential, > privileged or otherwise protected information, including legal protection > under the Health Insurance Portability and Accountability Act (HIPAA). If you > are not the above named intended recipient, you are hereby notified that any > use, disclosure, printing, copying, or distribution of this email or > attachments is strictly prohibited and may subject you to criminal and/or > civil penalties. If you have received this email in error, please immediately > notify the sender by telephone or reply email and destroy this email > > > > [Non-text portions of this message have been removed] > > > > ... > Please use the following Message Identifiers as your subject prefix: <SALES>, > <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> > > Job postings are welcome, but for job postings or requests for work: <JOBS> > IS REQUIRED in the subject line as a prefix. > Yahoo! Groups Links > > > > > -- %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% Brian Lehrhoff, EA ([EMAIL PROTECTED]) Messaging Consultant 201-913-4506 Upgrade your Quickbooks for 20% off at http://ea.brianlehrhoff.com Circular 230 Notice is located at http://ea.brianlehrhoff.com/230notice.html %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/EDI-L/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
