from your screenshot seems you have a JSON structure but not a JSON column. From String column this seems a bit complicated so I suggest transform your column into proper JSON column (String to JSON) and then try some JSON processing nodes to obtain your desired structure (also should be possible to get this column as JSON in KNIME from your database - check Output Type Mapping tab of database Connector node). Additionally if you share example data (doesn’t have to be real data, dummy that represents real well enough is good enough) someone might play with it and give suggestions/example workflow
if a parameter does not have the parameter i want to see NA.
Can you help me please?
I have transformed the column parsed_parameters in a json column on Knime, then I have used Json to table but it does not work…
considering you don’t have exact structure I would use JSON Path (Dictionary) node which is pretty handy if you know all possible parameters. In it you define column name and type plus it will return missing value (denoted in KNIME with red question mark) in case some parameter can not be found. Then, if needed, you can use Missing Value node to replace it with NA. Here is example workflow from you input data based on which you can continue…
Hi @ipazin, it does not work with json path. I can do it in R Studio. Can I connect it after R studio to Knime?
for example, I make a dataset in R Studio with what I want, then is it possible to read in Knime this dataset from R Studio?