Windows Server - XML Document debatch question

Asked By Jason

13-Jan-08 05:46 PM

Hi All

I have a document which is similar to below


there are 3 main elements


The goods elements has core data on goods which are common between a
tradeitem and non tradeitem.
It also contains an element which specifies if that good is a tradeitem or
not via the <istrade> element.

If the item is then it will have a corrosponding <tradeitem> element else
there will be a <nontradeitem> element.

What I need to to do is to separate all this data into two xml files.

Say trade.xml and nontrade.xml where each xml file will only contain data
relevant to them and in a new schema.

example

trade.xml


I have investigated looking into maps for this functionality but it appears
you cannot combine fields from two or more looping records into a single
destination record.
So with this being said, what would be the best way to achieve this? any
thoughts?

14-Jan-08 06:13 AM

Hi Jason,
You can still use a map and can use the index functoid if there is an
order you can rely on, otherwise you can use inline XSLT or XSLT Call
Template from within the scripting functoid in conjunction with a
mostly normal map.  If you're schema is that simple you can just use
the inline xslt and wire it to the root of your destination schemas
(one per destination schema).  I often find myself falling back on
XSLT because I've done it for so long, but with enough work you can
usually find a mapping way to get what you want.  If you do go down
the XSLT path XML Note Pad or the testing tools for the mapper should
be used to make your life easier.


s