>>sort the rows outside of the mapper. I second that. I have found this method to be much easier to deal with than finding some convoluted way to do it in gentran. I don't doubt there are ways of doing it in gentran, with arrays - or something else. But it sure is easy to sort things in the database instead.
Travis- -----Original Message----- From: Brian Lehrhoff [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 25, 2007 6:13 PM 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 ... 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/
