Hi to all!
After some manipulation with the data I have array like:
[
{“a”: “abc”},
{“a”:“def”}
]
And now my task is to filter this array and leave only [{“a”: “abc”}]
Explain please how I can solve this problem.
Thanks a lot!!!
Hello, Ivan!
This is JSON
Hello @Pavel_Msc,
would say you need JSON Path node for this task. Output column set to JSON (if that is what you need as output), path is $[0] and uncheck both List and Paths options.
Alternatively you can use JSON to Table followed by Columns to JSON node.
Br,
Ivan
Ivan, thanks a lot!
Yes, I try with JSON Path.
May be you can say me where I made mistake in path: column1[?(@.schema = ‘abc’ )]
KNIME write: "Expectwed character ) "
Hello @Pavel_Msc,
not sure. Not a JSON expert. Here is node’s configuration I used based on your input data.
Br,
Ivan