Help using xpath node

KNIME Analytics Platform
#1

Hello Knime forum!

I am trying out the xpath node in knime: in the xml file, I have an application object containing several solution objects, both objects with details (name and id). I want to convert this xml into a table, where I can show all application objects with details (app name and ID) with their respective contained solutions objects with detauls (solution name and Id). With the xpath I am only able to show either the application objects details or the solution object details, but not mapped together.. anyone has an idea on how to do the mapping between application object and respective solution object?

<>

#2

This is almost impossible to tell without seeing an example of the input and the expected output.

#3

Here is an example of the input and the expected output:

 

<ApplicationObject>

 <ObjectId>ApplicationID 1</ObjectId>

 <Name>AppName 1</Name>

 <ObjectType>Application</ObjectType>


  <SolutionObject>

  <ObjectId>solution id 1</ObjectId>

  <Name>solution name 1</Name>

  <ObjectType>Solution</ObjectType>

  </SolutionObject>


  <SolutionObject>

  <ObjectId>solution id 2</ObjectId>

  <Name>solution name 2</Name>

  <ObjectType>Solution</ObjectType>

  </SolutionObject>


  <SolutionObject>
 
  <ObjectId>solution id 3</ObjectId>

  <Name>solution name 3</Name>

  <ObjectType>Solution</ObjectType>

  </SolutionObject>

</ApplicationObject>


<ApplicationObject>

 <ObjectId>ApplicationID 2</ObjectId>

 <Name>AppName 2</Name>

 <ObjectType>Application</ObjectType>


  <SolutionObject>

  <ObjectId>solution id 4</ObjectId>

  <Name>solution name 4</Name>

  <ObjectType>Solution</ObjectType>

  </SolutionObject>

</ApplicationObject>


<ApplicationObject>

 <ObjectId>ApplicationID 3</ObjectId>

 <Name>AppName 3</Name>

 <ObjectType>Application</ObjectType>


  <SolutionObject>

  <ObjectId>solution id 5</ObjectId>

  <Name>solution name 5</Name>

  <ObjectType>Solution</ObjectType>

  </SolutionObject>

  <SolutionObject>

  <ObjectId>solution id 6</ObjectId>

  <Name>solution name 6</Name>

  <ObjectType>Solution</ObjectType>

  </SolutionObject>

</ApplicationObject>

 

OUTPUT:

Application ID Application Name Object type Solution ID Solution Name Object type
ApplicationID 1 AppName1 Application solution id 1 solution name 1 solution
ApplicationID 1 AppName1 Application solution id 2 solution name 2 solution
ApplicationID 1 AppName1 Application solution id 3 solution name 3 solution
ApplicationID 2 AppName2 Application solution id 4 solution name 4 solution
ApplicationID 3 AppName3 Application solution id 5 solution name 5 solution
ApplicationID 3 AppName3 Application solution id 6 solution name 6 solution

 

#4

Is my issue too ...

Thanks

Sergio

#5

This can be achieved with a few simple XPath expressions. Since several solutions are nested inside an application, you need two different XPath nodes. Have a look at the attached workflow.

#6

Thank you, it worked! :D