Icon

kn_​example_​json_​xpath_​dynamic_​search

use a JSON Path to dynamically extract information from an XML file
use a JSON Path to dynamically extract information from an XML file extract file name andextensionknime://knime.workflow/data/$ECUShortNames$ = "VGSNAG3" => TRUE(filter only the lines you want)$['VehicleReport'][*]['Component'][*]['ECUShortName']extract thedata fromthe nestedJSON pathconvert XML to JSONlist xml filesSTARTSTOPPand collectexcludeJSON cellsxml_fileknime://knime.workflow/data/result.table URL to File Path XML Reader Column Filter Rule-basedRow Filter JSON Path JSON Path Ungroup XML To JSON List Files(deprecated) Table Row ToVariable Loop Start Loop End Column Filter ConstantValue Column Column Resorter Table Writer use a JSON Path to dynamically extract information from an XML file extract file name andextensionknime://knime.workflow/data/$ECUShortNames$ = "VGSNAG3" => TRUE(filter only the lines you want)$['VehicleReport'][*]['Component'][*]['ECUShortName']extract thedata fromthe nestedJSON pathconvert XML to JSONlist xml filesSTARTSTOPPand collectexcludeJSON cellsxml_fileknime://knime.workflow/data/result.tableURL to File Path XML Reader Column Filter Rule-basedRow Filter JSON Path JSON Path Ungroup XML To JSON List Files(deprecated) Table Row ToVariable Loop Start Loop End Column Filter ConstantValue Column Column Resorter Table Writer

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: m_lauber
Created at: 2021-02-25
On NodePit since: 2021-02-26
Last update: 2024-11-21
Created with KNIME version: v4.3.1

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

Try NodePit Runner!