Re: [xsl] Merge 2 xmls : Loop through one xml and get elements from second xml

["Martin Honnen martin.honnen@xxxxxx" <xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx>]

Am 01.09.2020 um 15:51 schrieb Prady Prady prady.chin@xxxxxxxxx:
> Is there any other simpler way..

What do you consider simple or simpler? Using XSLT 2 or 3? Sure, go ahead

<xsl:template match="order">
  <xsl:copy>
    <xsl:apply-templates select="@* | node(), key('order',
$ordernumber, $doc2)/amount"/>
  </xsl:copy>
</xsl:template>

> All I have to do is:
>
> Loop thru first xml:
> add elements from first xml
> getB  "amount" from second xml where order number matches and create this
> Or
>
> Can you explain what is being done?

The suggested approach processes the first XML with the identity
transformation to copy everything, with the exception of of the "order"
elements, where it additionally gets the "amount" from the second XML,
using a key to establish the match and selection based on the order number.


>      > But I need to use only XSLT 1.0
>
>     Declare
>
>     <xsl:param name="doc2" select="document('Orders_Part2.xml')"/>
>
>     and a key
>
>     <xsl:key name="order" match="order" use="order_number"/>
>
>     then use
>
>     <xsl:template match="order">
>      B  B <xsl:copy>
>      B  B  B <xsl:apply-templates select="@* | node()"/>
>      B  B  B <xsl:variable name="ordernumber" select="order_number"/>
>      B  B  B <xsl:for-each select="$doc2">
>      B  B  B  B <xsl:apply-templates select="key('order',
>     $ordernumber)/amount"/>
>      B  B  B </xsl:for-each>
>      B  B </xsl:copy>
>     </xsl:template>
>
>     plus the identity transformation
>
>     <xsl:template match="@* | node()">
>      B  B <xsl:copy>
>      B  B  B <xsl:apply-templates select="@* | node()"/>
>      B  B </xsl:copy>
>     </xsl:template>
>
>
>
>      >>>B  B  B =================
>      >>>B  B  B Merge 2 xmls : Loop through one xml and get elements from
>     second xml
>      >>>
>      >>>B  B  B I have 2 xmls(Orders_Part1.xml,Orders_Part2.xml). I have to
>     build the
>      >>>B  B  B 3rd xml ( Orders.xml) .