JSON Columns

Hello, I am having some trouble with using a Table View node to display a JSON file from a JSON Reader node. So far when I open views I have individual rows with all of the corresponding data, however the column names show up in the row information. I have a screenshot attached. Is there a way to get the columns to display correctly?

Hi @Ramfran, welcome to the forum.

What nodes are you using after the JSON Reader? It would be helpful if you posted a workflow with what you have so far.

Hi, yeah im only supposed to use the Table View node
jflow


Hello @Ramfran,

welcome to KNIME Community!

Table View node displays data with the same number of columns/rows as there is in preceding node. In your case that node is JSON Reader node. If you right click on it and click JSON table at the bottom you’ll see same data (a bit different format) but not in HTML. To go from JSON into “normal” data table where sepalLength/Width would be column names you can use JSON to Table node.

Br,
Ivan

2 Likes

Thank you that works great!

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.