I have been scratching my head all day long with this problem and it is very hard to describe. I have a workflow that calls an API which retrieves a JSON with many objects and fields. When I use the JSON path for the fields I need, I get all the info I need. However, if one of the requested fields is not available KNIME inserts a ‘?’ which means missing value. Up to this point, everything looks good.
The problem, which I don’t see on my local KNIME only on the web portal, is that the values shift upwards even if I do a rule engine, java snippet or missign value node to replace the missing value with a string like “NOT AVAILABLE”. Again this only happens on the server, I guess its possible that the server needs to be upgraded but to shift values like this?
It would be nice if I could specify a value in case the field is missing.