Table to JSON

Converts the selected columns content to a JSON value row-wise or column-wise. It also has an option to "undo" - with some limitations - the JSON to Table transformation, and can create JSON values for each row based on the column names.
Example input table:

a.ba.cdb0c0d0b1c1d1 With the different parameters, the following JSON values are generated:
Row-oriented(datatable as one JSON value):

[ {
  "a.b" : "b0",
  "a.c" : "c0",
  "d" : "d0"
}, {
  "a.b" : "b1",
  "a.c" : "c1",
  "d" : "d1"
} ]

Keep rows (column names treated as paths, default separator: . ):

{
  "a" : {
    "b" : "b0",
    "c" : "c0"
  },
  "d" : "d0"
}

{
  "a" : {
    "b" : "b1",
    "c" : "c1"
  },
  "d" : "d1"
}

Column-oriented (row keys as JSON value, with the key: "ROWID"):

{
  "ROWID" : [ "Row0", "Row1" ],
  "a.b" : [ "b0", "b1" ],
  "a.c" : [ "c0", "c1" ],
  "d" : [ "d0", "d1" ]
}

Input ports

1. Type: Table
   Table
   A datatable

Output ports

1. Type: Table
   JSON
   Table containing the JSON column