copying Parent XML tag value to child tag value

[#1]

Hi Team , 

                Could you please help me in working with XML tag's in Nifi. I've a scenario where i need to look for the parent xml tag value in entire document, the corresponding child xml tag value should match. if it is not matching we should copy the parent xml tag value to the corresponding specified child tag.

here the parent tag is <OriginalQTY name=" 5.000">    and the child tag should match is <OriginalORDEREDPURCHASEQUANTITY>   So every time <OriginalORDEREDPURCHASEQUANTITY> should match <OriginalQTY> value in name.

<Document>
<PURCHPURCHASEORDERHEADERV2ENTITY>
<VENDORACCOUNT>XXXXX</VENDORACCOUNT>
<CURRENCYCODE>ZAR</CURRENCYCODE>
<OriginalQTY name=" 1.000">
<PURCHPURCHASEORDERLINEV2ENTITY>
<PURCHASEORDERNUMBER>PO-XXXXXXX</PURCHASEORDERNUMBER>
<LINENUMBER>0000000100</LINENUMBER>
<PURCHASEPRICE>???</PURCHASEPRICE>
<ITEMNUMBER>XXXXXXXXX</ITEMNUMBER>
<CONFIRMEDQUANTITY> 0.000</CONFIRMEDQUANTITY>
<OriginalORDEREDPURCHASEQUANTITY> 7.000</OriginalORDEREDPURCHASEQUANTITY>
</OriginalQTY>
<OriginalQTY name=" 5.000">
<PURCHPURCHASEORDERLINEV2ENTITY>
<PURCHASEORDERNUMBER>PO-XXXXXXXXX</PURCHASEORDERNUMBER>
<LINENUMBER>0000000100</LINENUMBER>
<PURCHASEPRICE>???</PURCHASEPRICE>
<ITEMNUMBER>A4634101302</ITEMNUMBER>
<CONFIRMEDQUANTITY> 0.000</CONFIRMEDQUANTITY>
<OriginalORDEREDPURCHASEQUANTITY> 7.000</OriginalORDEREDPURCHASEQUANTITY>
</OriginalQTY>
</PURCHPURCHASEORDERHEADERV2ENTITY>
</Document>

[#2]

@mburgess Could you please help on this? thank you!!

[#3 · Accepted solution]

Hi,

Are you looking to copy the value from the parent tag name attribute "<OriginalQTY name=" 5.000">" to the value of the child tag "<OriginalORDEREDPURCHASEQUANTITY>" so that its matching all the time? If so you can try the TransformXML processor with the following script:

<?xml version="1.0" encoding="UTF-8" ?>
<xsl:transform xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0">
 <xsl:template match="@*|node()">
        <xsl:copy>
            <xsl:apply-templates select="@*|node()"/>
        </xsl:copy>
    </xsl:template>
    <xsl:template match="Document/PURCHPURCHASEORDERHEADERV2ENTITY/OriginalQTY/PURCHPURCHASEORDERLINEV2ENTITY/OriginalORDEREDPURCHASEQUANTITY">
        <xsl:copy>
             <xsl:value-of select="../../@name"/>
        </xsl:copy>
    </xsl:template>
</xsl:transform>

If you find that helpful please accept solution. Thanks

[#4]

Yes that's the requirement.

Thank you so much @SAMSAL , it worked. perfectly, Could you please help me any sources to get used to these xml scripts.