XPath - Exclude Fields

KNIME Analytics Platform
1

Hi,

i’m using jsonpath to extract some information, however the structure is a bit tricky.

e.g.:

<DescriptorName>Fenthion<SourceList>
       <Source>MeSH</Source>
    </SourceList>
</DescriptorName>

i would only want to have the descriptorname without the source information.
is there a way to call the descriptor and ignore the sourcelist/source ?

many thanks in advance

Andreas

2

So your JSON data contains actually embedded XML? You could strip away the undesired parts using a String Manipulation node and a regex.

– Philipp

3

Hi

sorry
it is xpath not jsonpath…
bit too warm today over here :smiley: