AnsweredAssumed Answered

how do I modify xml using query xml action item.

Question asked by nehaagrawal on Aug 6, 2015
Latest reply on Aug 14, 2015 by nehaagrawal

Hello all,


I am new to this community and posting for the first time.


I am trying to modify below XML:


<ValueData xmlns=""><Value xsi:type="xsd:string" xmlns:xsi="">Proteomics</Value></ValueData>

<ValueData xmlns=""><Value xsi:type="xsd:string" xmlns:xsi="">Metabolomics</Value></ValueData>

<ValueData xmlns=""><Value xsi:type="xsd:string" xmlns:xsi="">Bioinformatics</Value></ValueData>

<ValueData xmlns=""><Value xsi:type="xsd:string" xmlns:xsi="">Mass Spectrometry</Value></ValueData>



to get the output as:



<ValueData><Value xsi:type="xsd:string" xmlns:xsi="">Proteomics</Value></ValueData>

<ValueData><Value xsi:type="xsd:string" xmlns:xsi="">Metabolomics</Value></ValueData>

<ValueData><Value xsi:type="xsd:string" xmlns:xsi="">Bioinformatics</Value></ValueData>

<ValueData><Value xsi:type="xsd:string" xmlns:xsi="">Mass Spectrometry</Value></ValueData>



I want to remove attribute  xmlns from each <ValueData> tag. I tried doing this using XSLT with no luck. Any idea how to do that?