06-29-2020 04:51 AM
Team,
I am looking for a solution in snaplogic to convert the xml attribute to xml element.
My xml looks like this,
Bloodroot ColumbineThanks,
Dhivya Aroma
Solved! Go to Solution.
06-29-2020 07:31 AM
Attached is an example pipeline. Note that you will need to extend the XSD defined for the XML Formatter, but this should solve this request.
Example_XML_attributes_to_elements_2020_06_29.slp (7.8 KB)
Note that you will need to rename the following attachments to remove the “.txt” extension - this was done just so I could upload.
catalog_with_attributes.xsd.txt (762 Bytes) catalog_with_attributes.xml.txt (201 Bytes)
06-29-2020 05:43 AM
I do not see your xml attached to your post.
06-29-2020 06:14 AM
Sorry. Only values are pasted and not the tags.
<catalog>
<plant botanical="Sanguinaria canadensis" zone="4" light="Mostly Shady">Bloodroot</plant>
<plant botanical="Aquilegia canadensis" zone="3" light="Mostly Shady">Columbine</plant>
</catalog>
06-29-2020 06:26 AM
Thank you for providing your input. Can you also provide an example of your desired output?
06-29-2020 06:51 AM
This is the expected result
<catalog>
<plant>
<botanical>Sanguinaria canadensis</botanical>
<zone>4</zone>
<light>Mostly Shady</light>
<plantValue>Bloodroot</plantValue>
</plant>
<plant>
<botanical>Aquilegia canadensis</botanical>
<zone>3</zone>
<light>Mostly Shady</light>
<plantValue>Columbine</plantValue>
</plant>
</catalog>
Once all the attributes are converted to element the final value of plant (i.e., Columbine) needs the new tag name, like here, I have provided plantValue.