Converts the selected columns content to a JSON value row-wise or column-wise. It also have an option to "undo" -with some limitations- the JSON to Table transformation and create JSON values for each row based on the column names.
Example input table:
Row-oriented
[ { "a.b" : "b0", "a.c" : "c0", "d" : "d0" }, { "a.b" : "b1", "a.c" : "c1", "d" : "d1" } ]Column-oriented (with Row keys as JSON value with key: "ROWID"):
{ "ROWID" : [ "Row0", "Row1" ], "a.b" : [ "b0", "b1" ], "a.c" : [ "c0", "c1" ], "d" : [ "d0", "d1" ] }Keep rows (with Column names as paths , separator: . ):
{ "a" : { "b" : "b0", "c" : "c0" }, "d" : "d0" }
{ "a" : { "b" : "b1", "c" : "c1" }, "d" : "d1" }