AnsweredAssumed Answered

How to allocate EDI file portions into multiple files

Question asked by matthew.jiang707767 on Mar 21, 2018

Hi Boomi community, 

 

I am working on a 814 EDI file mapping. I am aware that I can split EDI files into multiple files based on a specific field. However, in my case, I got an incoming EDI file with multiple fields that needs to be allocated into separate database records. I am having difficulties on splitting and allocating them. 

 

Below I am attaching a sample file and requirement. Any suggestions will be appreciated. 

 

Thanks,

Matthew

 

For the following EDI file, the requirement is as below.

1) First record to include the black and green text

2) Second record to include the black and orange text

 

ST|814|000016649~

BGN|11|8142018030820513749000016649|20180308~

N1|8S||1|006912877||41~

N1|SJ||1|080977851||40~

N1|8R|CUSTOMER NAME~

N3|3004 MISSION ST~

N4|SANTA CRUZ|CA|95060~

PER|IC||TE|5555555555~

N1|BT|PACIFIC COLLEGIATE SCH~

N3|3004 MISSION ST~

N4|SANTA CRUZ|CA|95060~

LIN|00001|SV|EL|SV|CE~

ASI|WQ|021~

REF|11|1111111111~

REF|12|1111111111~

REF|AS|006912877~

REF|7F|N~

REF|BF|B~

REF|PC|DUAL~

REF|BLT|LDC|006912877~

REF|9V|N~

REF|9W|N~

REF|UU|V49~

DTM|007||||D8|20180320~

NM1|MQ|3~

REF|18|LDC~

REF|4L|S~

REF|91|L~

REF|4L|S~

REF|91|L~

REF|LO|A1~

REF|LU||10143288740045605~

REF|LU||10143288740045610~

REF|D7|N~

REF|MG|1700T9~

REF|MG|4368R8~

REF|NH|A1~

REF|SC|M~

REF|SC|M~

REF|SU|N~

REF|TZ|X~

REF|TZ|X~

REF|VE|LDC|006912877~

REF|VR|LDC|006912877~

REF|VA|LDC|006912877~

REF|V9|LDC|006912877~

REF|GE|T~

REF|GE|T~

SE|49|000016649~

Outcomes