Mapping two fields of one schema to two rows of another schema.   

I'm trying to map:
<root>
  <tradeDate>20060411</tradeDate>
  <settleDate>20060418</settleDate>
</root>
to:
<new>
  <dates>
    <code>SETT</code>
    <date>20060418</date>
  </dates>
  <dates>
    <code>TRAD</code>
    <date>20060418</date>
  <dates>
</new>

Any suggestions?

date: Thu, 18 May 2006 08:41:02 -0700   author:   jlewisp

Re: Mapping two fields of one schema to two rows of another schema.   

I would use the table looping functoid and table extractor functoids, 
creating two rows in the table functoid and then extracting the two rows.

Eric
http://stottcreations.com/blog

"jlewisp"  wrote in message 
news:370269DF-0573-4565-9169-1D58241E6882@microsoft.com...
> I'm trying to map:
> <root>
>  <tradeDate>20060411</tradeDate>
>  <settleDate>20060418</settleDate>
> </root>
> to:
> <new>
>  <dates>
>    <code>SETT</code>
>    <date>20060418</date>
>  </dates>
>  <dates>
>    <code>TRAD</code>
>    <date>20060418</date>
>  <dates>
> </new>
>
> Any suggestions?

date: Thu, 18 May 2006 10:16:13 -0700   author:   Eric Stott