Icon

xml replacer with xml demo files -knime 4.x

demonstrates using XSLT to update Names on one XML based on Names for IDs that have been changed in a different XML.

It reads Identifier and Name from both XMLS using XPath, then finds the changes to names for existing IDs, and applies XSLT to update them.



@takbb Brian Bates 26 Mar 2024

convert back to xml datatypetransform XMLfix xml datatypefor xsltcreate templatesNode 14include the xsl templatefor each identifierwithin the base xlst templatebase xmlcreate an xsl templatefor each name to be updatedremove default namespace(KNIME uses XSLT 1.0 whichmakes handling default namespacesmore challenging)xml with some changesget id and namefrom base xmlmatch on idto find updatednamesidentifierswith changed nameget id and name fromupdated xmlBase XSLT texttemplateidentifiers andupdated-namelistString To XML XSLT String To XML GroupBy Table Rowto Variable String Manipulation XML Reader String Manipulation String Manipulation XML Reader XPath Joiner Rule-basedRow Filter XPath Table Creator Column Rename convert back to xml datatypetransform XMLfix xml datatypefor xsltcreate templatesNode 14include the xsl templatefor each identifierwithin the base xlst templatebase xmlcreate an xsl templatefor each name to be updatedremove default namespace(KNIME uses XSLT 1.0 whichmakes handling default namespacesmore challenging)xml with some changesget id and namefrom base xmlmatch on idto find updatednamesidentifierswith changed nameget id and name fromupdated xmlBase XSLT texttemplateidentifiers andupdated-namelistString To XML XSLT String To XML GroupBy Table Rowto Variable String Manipulation XML Reader String Manipulation String Manipulation XML Reader XPath Joiner Rule-basedRow Filter XPath Table Creator Column Rename

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: bbate
Created at: 2024-03-13
On NodePit since: 2024-03-27
Last update: 2024-04-27
Created with KNIME version: v4.7.8

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!