Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Biz Talk NonXML > Trouble Flatten...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 7 Topic 941 of 978
Post > Topic >>

Trouble Flattening EDI data

by =?Utf-8?B?RG9uYWxkIEh1cmxleQ==?= <DonaldHurley@[EMAIL PROTECTED] Jun 25, 2007 at 04:52 AM

Hi

I am having trouble flattening EDI data. 

BGM++GBBHXAUSJFKAAUN10485+++ACW:0496++AB'
DTM+164:9111120230:201'
TDT+20+305+4+++BA:172:3'
LOC+5:LHR:163:3'
LOC+13:AMS:163:3'
DTM+189:9111120800:201'
DTM+232:9111120940:201'
TDT+20+175+4+++KL:172:3'
LOC+5:AMS:163:3'
LOC+7:JFK:163:3'
DTM+189:9111121100:201'
DTM+232:9111121400:201'
MEA+WT+AAD+KGM:476.9'
MEA+CT+SQ+NMB:8'

The 2 mea records at the bottom need to go to different fields in the same

record.  I use 2 equal functoids to determine if they are AAD or SQ, and 2

Value Mapping (Flattening) functoids to put them into different fields,
but 
they always produce 2 records. In looking at the do***entation an another 
post in .General  "Help on Looping and Value Mapping functoid".  This
should 
work.  But I am getting 2 records.  

DIDGBB                 911112    ACW0496476.9       AB 
DIDGBB                 911112    ACW0496      8     AB 

Is this the correct way to go about this?  What could I be doing wrong.

TIA
Don
 




 7 Posts in Topic:
Trouble Flattening EDI data
=?Utf-8?B?RG9uYWxkIEh1cmx  2007-06-25 04:52:00 
RE: Trouble Flattening EDI data
=?Utf-8?B?RG9uYWxkIEh1cmx  2007-06-25 05:10:04 
Re: Trouble Flattening EDI data
"Eric Stott" &l  2007-06-25 13:57:24 
Re: Trouble Flattening EDI data
=?Utf-8?B?RG9uYWxkIEh1cmx  2007-06-26 04:27:00 
Re: Trouble Flattening EDI data
=?Utf-8?B?RG9uYWxkIEh1cmx  2007-06-26 04:36:00 
Re: Trouble Flattening EDI data
"Eric Stott" &l  2007-06-26 09:22:41 
Re: Trouble Flattening EDI data
"Jim Dawson" &l  2007-06-26 14:42:31 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 5:47:32 CST 2008.