Hi there,

Is this possible to achieve usign XSLT?

This is my source XML

<RootNode>
    <Supplementary>
        <ValueItem>
            <RelatedEntityRef RelatedID="V1"/>
            <PercentOwned>
                <RelatedEntityRef RelatedID="Party-Person-1" ChangeOfNameRequired="No" Payment="200"/>
            </PercentOwned>
            <Asset>Car</Asset>
        </ValueItem>
        <ValueItem>
            <RelatedEntityRef RelatedID="V2"/>
            <PercentOwned>
                <RelatedEntityRef RelatedID="Party-Person-2" ChangeOfNameRequired="No" Payment="100"/>
            </PercentOwned>
            <PercentOwned>
                <RelatedEntityRef RelatedID="Party-Person-2" ChangeOfNameRequired="No" Payment="300"/>
            </PercentOwned>
            <Asset>Piano</Asset>
        </ValueItem>
    </Supplementary>
    <Main>
        <ValueItem>
            <Identifier UniqueID="V1"/>
            <PercentOwned>
                <RelatedEntityRef RelatedID="Party-Person-1"/>
            </PercentOwned>
        </ValueItem>
        <ValueItem>
            <Identifier UniqueID="V2"/>
            <PercentOwned>
                <RelatedEntityRef RelatedID="Party-Person-2" SecondHand="Yes"/>
            </PercentOwned>
            <PercentOwned>
                <RelatedEntityRef RelatedID="Party-Person-2" SecondHand="Yes"/>
            </PercentOwned>
        </ValueItem>
    </Main>
</RootNode>


and to be transformed into

<RootNode>
    <Main>
        <ValueItem>
            <Identifier UniqueID="V1"/>
            <PercentOwned>
                <RelatedEntityRef RelatedID="Party-Person-1" SecondHand="Yes" ChangeOfNameRequired="No">
                    <Payment>200</Payment>
                </RelatedEntityRef>
            </PercentOwned>
            <Asset>Piano</Asset>
        </ValueItem>
        <ValueItem>
            <Identifier UniqueID="V2"/>
            <PercentOwned>
                <RelatedEntityRef RelatedID="Party-Person-2" SecondHand="Yes" ChangeOfNameRequired="No">
                    <Payment>100</Payment>
                    <Payment>300</Payment>
                </RelatedEntityRef>
            </PercentOwned>
        </ValueItem>
    </Main>
</RootNode>


Thanks

Hi again,

Just to add a bit of background. Basically, I am trying to merge stuff from the supplementary node to the main node. And then converting the Payment attribure into an element as I dont wish to repeat the \\PercentOwned\RelatedEntityRef element as the other attributes within the RelatedEntityRef element as exactly the same.

thanks again.