ScrewBalll
Programmer
Hi There,
I'm in need of some help regarding creatiung a map in Biztalk. I want to map one flat file to another, unfortunately there isn't any heirarchy created in the source schema so I need to try and implememt some relationships.
Probably best to show an example.
I have a source file with basically two or more distinct tables in it, I need to 'join' these tables to create a single one.
eg.
<record1a>
<ID> Number1 </ID>
<Height> 1.82m </Height>
</record1a>
<record1b>
<ID> Number1 <ID>
<Weight> 70kg </Weight>
<record1b>
From this schema I want to map it to:
<record1>
<ID> Number1 </ID>
<Height> 1.82m </Height>
<Weight> 70kg </Weight>
</record1>
I can't change the source schema, so I must use some sort of mapping. I've been trying out using equals and value-mapping functoids but as of yet I can't get them to work.
Anyone out there got any ideas?
Cheers.
I'm in need of some help regarding creatiung a map in Biztalk. I want to map one flat file to another, unfortunately there isn't any heirarchy created in the source schema so I need to try and implememt some relationships.
Probably best to show an example.
I have a source file with basically two or more distinct tables in it, I need to 'join' these tables to create a single one.
eg.
<record1a>
<ID> Number1 </ID>
<Height> 1.82m </Height>
</record1a>
<record1b>
<ID> Number1 <ID>
<Weight> 70kg </Weight>
<record1b>
From this schema I want to map it to:
<record1>
<ID> Number1 </ID>
<Height> 1.82m </Height>
<Weight> 70kg </Weight>
</record1>
I can't change the source schema, so I must use some sort of mapping. I've been trying out using equals and value-mapping functoids but as of yet I can't get them to work.
Anyone out there got any ideas?
Cheers.