TrustedLink Mapping 1

[edianalyst]

I'm new to EDI mapping and would really appreciate if anyone could tell me how I could change the output data for an 850 to flat file map so that data is arranged in one single line.

i.e. right now the output data is like this:

PO12345
Style1 6 EA H1234567
Style2 7 EA H1234567
Style3 12 EA H1234567
Style4 9 EA H1234567

PO23456
Style1 6 EA H2345678
Style2 7 EA H2345678
Style3 12 EA H2345678
Style4 9 EA H2345678

and I would like the data to be like this:

PO12345 Style1 6 EA H1234567
PO12345 Style2 7 EA H1234567
PO12345 Style3 12 EA H1234567
PO12345 Style4 9 EA H1234567

PO23456 Style1 6 EA H2345678
PO23456 Style2 7 EA H2345678
PO23456 Style3 12 EA H2345678
PO23456 Style4 9 EA H2345678

 

[sayeers]

I assume you are trying to have some header information (from PO1 segment ) repeated on all the line level segments.
Best way to do this is to store the POnumber at the header level stored in a stored field and then have that one on the each of the line level records.

BTW what back end application are you on??

 

[edianalyst]

you mean what app we're interfacing to?

 

[sayeers]

I asked this question since most of the ERP applications I know of support the 'denormalised' format so to speak.

Leaving that aside, I take that you mean to say multiple 'records' on one 'Line'. You can try the TLE mapping command 'Write without carriage return'. This has to be preceded by 'write staging key command'

Let me know if this works.

 

[edianalyst]

I did some trial/error testing and got my map to print the data in the format I'd like, however, for some reason, the output file created is adding this ITMA to the first column of all output files, any ideas on how to remove that?