how can I make a list value of JSON to row

KNIME Analytics Platform
#1

For example, there is a value as [ {"c1":1, "c2":2, "c3":3}, {"c1":10, "c2":20, "c3":30} ,,, {"c1":1, "c2":2, "c3":3}] in JSON document.

I want to change it to rows in order to insert them into a table tab1(c1 int, c2 int, c3 int).

To do it, the value need to be changed like this:

  "c1"   "c2"  "c3"

   1        2      3

   10     20    30

......

     1   2   3

#2

Hi Hyun,

I have created an example that does this for you, see attached.

Cheers,

Roland