ganfv&r

Hi
I have a source schema which looks like this
<MyNode>
<record>
<header>
<member1>
<member2>
</record>
<record>
<header>
<member1>
<member2>
<member2>
</record>
<MyNode>

I want to map only the last "<member>" record to destination schema
conditionally. If i take recordcount it gives total number of records in
whole message (in this case 5)If i use inline XSLT then i can output the
recordcount in the script functoid so that i can compare it.
Please help me out to solve this problem.
--
Thanks and Regards,
Gan

keith newton

Hi,

You need to make sure you have all your min occurs and max occurs attributes
set on the schema that describes your xml message. They are very important
to how the record count functoid works... If that doesn't work are you able
to send your xsd file as an attachment or something ?

Cheers, Keith

ganfv&r

Hi Keith,
Thanks for your reply.
My schema is fine.
Microsoft says that the Recordcount functoid returns the total number of
record for the whole message and not for inner nodes loop.
I need some way to find record count for my inned node which occurs multiple
times.
Please let me know if there is a way for find that.

--
Thanks and Regards,
Gan

keith newton

Right you are Gan, I was mixing up something I have done with the sum
functoid in the past with the record count. Just tried building what your
talking about and I can see what your up against.

Since you have worked out how to get the record count using Xslt, could you
use Xslt to select the last member record to copy across ? Can the "record"
node only contain "header", "member1" and "member2" records ?

Cheers, Keith

ganfv&r

Hi Keith,
Actually <member> itself is a node and has other fields and elements.
i need to map all of them to destination schema.
So if i use XSlt them its almost like i have to write whole mapping in Xslt
for all of the mapping which i dont want to do. if i do that all then why is
the mapper for?
I need to compare the record count to the n th record and find whether its
the last record and then bind the other elements and fields accordingly.
Let me know if you find anything on this.

--
Thanks and Regards,
Gan