Hi Chris, I would like to give my comments for this,
Please use the indexes(counter) and increment the counter inside the qualifier condition, so that all the values would be populated to destination. Also we need to remember that if any occurrence of the TEMP FIELD receives NULL values then the following occurrences will be drop out by Translator. Please let me know if you require more help!!!! -- Thanks, Makesh Elangovan +91-8970051116 On Wed, Jan 12, 2011 at 6:01 AM, Chris Johnson <[email protected] > wrote: > > > Quoted text is from <7175a0c865554cee804cf2a1c1516...@desktop1>, by > Michael Mattias/LS <[email protected] <mcmlserve%40talsystems.com>> > > > >I think perhaps trying to 'flatten out' a document which can be nested > >this > >deeply to map it to a SINGLE flat file or database table might be a tad > >ambitious. For sure it will leave "holes" in the output when something > >is > >"not present in this particular document/loop/segment" > > Any hierarchical structure in which you have a group structure with a > finite number of repetitions *can* be resolved down to a single flat > record. For EDIFACT if you use the tag+qualifier combination to select > desired instances from individual repetitions then you do not end up > with ' holes' in your target record unless that data is missing from the > EDI. > > For cases where groups, although not infinitely repeatable, can have a > widely varying number of repetitions and each instance is not uniquely > defined (such as at detail level) then you would get holes; since your > target record must have defined positions to accommodate data from the > maximum number of repetitions, which is why when mapping to a > spreadsheet you normally have one record per detail line and replicate > the header information on each line. > > All of which is far too general to be of value to the OP :-( > > Regards > Chris > -- > Chris Johnson mobile:+44 (0)7785 302122 Fax: +44 (0)870 0519 818 > EDI website http://www.edimatrix.co.uk > EDIMatrix Ltd work: 0845 126 0680 or +44 20 8778 1402 > Registered in UK no. 2777624 Reg.Office: 34 Sydenham Rd, London SE26 5QF > > [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 <*> 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: [email protected] [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/
