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 General > Question about ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 13562 of 13845
Post > Topic >>

Question about Mapping Flat File

by =?Utf-8?B?RWxsZW4gRGVhaw==?= <ellen@[EMAIL PROTECTED] > Jul 23, 2008 at 01:38 PM

I have a fixed width flat file that looks something like this:

     Field1  Field2  Field3   Field4  Field5

I want to normalize the data so that Field2 and Field4 become node levels 
and get something like this

     <Order>
	Field2
	<parts>
		Field4
		<requirements>
			Field1
			Field3
			Field5

I don't see a way in a map to tell it to create a new node when the value
in 
Field2 changes.

We're thinking about creating a custom pipeline so that we can parse
through 
the file in VB and reformat it that way. I'm hoping some of you might be
able 
to provide simpler alternatives.
-- 
Ellen Deak
 




 2 Posts in Topic:
Question about Mapping Flat File
=?Utf-8?B?RWxsZW4gRGVhaw=  2008-07-23 13:38:04 
Re: Question about Mapping Flat File
Frederik Van Lierde <f  2008-07-24 06:59:01 

Post A Reply:
  Go here to Signup

AddThis Feed Button


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

Contact
tan12V112 Fri Nov 21 8:07:54 CST 2008.