Brian, I am in Gentran Server for Windows 5.1. How would you recommend sorting the rows outside of the mapper, and running a second mapping?
Thanks, Adam -----Original Message----- From: Brian Lehrhoff [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 25, 2007 18:13 To: Becker, Adam Cc: EDI-L Mailing List Subject: Re: [EDI-L] Gentran Mapping Question 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/
