XML schema from a covariance matrix

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

XML schema from a covariance matrix

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Ask XML questions here] >> BizTalkers >> XML schema from a covariance matrix

Page: [1]

Message

<< Older Topic Newer Topic >>

XML schema from a covariance matrix - 24 February 2008

prd

Posts: 2
Score: 0
Joined: 24 February 2008
Status: offline

Hello,

I have a flat file containing a covariance matrix that I need to create an XML schema from so BizTalk can update a SQL database (using updategrams).

The flat file format is as follows:

name, apple, banana, orange
apple, 1.568, 2.504,   3.597
banana,2.504, 6.321,   8.878
orange,3.597, 8.878,   9.904

The database table I need to update is as follows:

Fruit1
Fruit2
Covariance

How can I create a schema so that I'll be able to insert/update rows of, for example, "Fruit1=apple, Fruit2=banana, Covariance=2.504"?

Basically, each row needs to create 3 records (not just 1). Taking the first row for example:

<record>
   <fruit1>apple</fruit1>
   <fruit2>apple</fruit2>
   <covar>1.568</covar>
</record>
<record>
   <fruit1>apple</fruit1>
   <fruit2>banana</fruit2>
   <covar>1.568</covar>
</record>
<record>
   <fruit1>apple</fruit1>
   <fruit2>orange</fruit2>
   <covar>1.568</covar>
</record>

Any help would be appreciated .