SeanHoppe.com > CLEO Mapping Examples > 3 How to Write Multiple Records On a Single Segment

How to Write Multiple Records On a Single Segment


Scenario

There are times in CLEO EDI Integrator (EEI) that we need to perform multiple writes to table/file, for a single segment. Take the MSG segment and how data is sent in the MSG02 element. The MSG02 segment is 248 characters in length but our field: ENNTE is ONLY 60 characters in length.


CLEO Integrator multiple writes elements

In the example below we are capturing

  • The first 60 characters in the first MSG02 instance - position 1 thru 60
  • The 2nd set of 60 characters in the 2nd MSG02 instance - position 61 thru 120
  • The 3rd set of 60 characters in the 3rd MSG02 instance - position 121 thru 180
  • The 4th set of 60 characters in the 4th MSG02 instance - position 181 thru 240

CLEO Integrator multiple writes substring elements

Update Format/Record:


Once the elements are updated, place an 'F' on the MSG segment..
CLEO Integrator multiple writes Update Segment

Update the MOVE ACTION to "B"

CLEO Integrator multiple writes segment format

Result:


Each time the field ENNTE is referenced a new VEDXPON is created.




By:
Sean Hoppe
on
EXTOL Business Partner Logo

More CLEO Examples

We have over 300+ examples of how CLEO can be customized to meet your organization's needs

Each of our examples are free to review and use.