{"title":"Table to JSON","nodeType":"Manipulator","id":"*xsMeCA0QgX92370E","factoryName":"org.knime.json.node.fromtable.TableToJsonNodeFactory","factoryId":"org.knime.json.node.fromtable.TableToJsonNodeFactory","path":["Structured Data","JSON"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"

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.\n
\n Example input table:\n

a.ba.cdb0c0d0b1c1d1\n With the different parameters, the following JSON values are generated:\n
\n Row-oriented(datatable as one JSON value):
[ {\n  "a.b" : "b0",\n  "a.c" : "c0",\n  "d" : "d0"\n}, {\n  "a.b" : "b1",\n  "a.c" : "c1",\n  "d" : "d1"\n} ]
\n \n Keep rows\n (column names treated as paths, default separator: \n .\n ):\n\n 
{\n  "a" : {\n    "b" : "b0",\n    "c" : "c0"\n  },\n  "d" : "d0"\n}
\n \n 
{\n  "a" : {\n    "b" : "b1",\n    "c" : "c1"\n  },\n  "d" : "d1"\n}\n
\n \n Column-oriented\n (row keys as JSON value, with the key: "ROWID"):\n\n 
{\n  "ROWID" : [ "Row0", "Row1" ],\n  "a.b" : [ "b0", "b1" ],\n  "a.c" : [ "c0", "c1" ],\n  "d" : [ "d0", "d1" ]\n}
\n \n \n ","shortDescription":"Converts some columns of a table to a single JSON cell.","keywords":[],"deprecated":false,"streamable":false,"tags":["Structured Data","JSON"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyhpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMTExIDc5LjE1ODMyNSwgMjAxNS8wOS8xMC0wMToxMDoyMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6MUVCQ0M5NDhFRjU5MTFFNUJCQTVFNkU1RjA4Rjk4QjMiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6MUVCQ0M5NDlFRjU5MTFFNUJCQTVFNkU1RjA4Rjk4QjMiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDoxRUJDQzk0NkVGNTkxMUU1QkJBNUU2RTVGMDhGOThCMyIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDoxRUJDQzk0N0VGNTkxMUU1QkJBNUU2RTVGMDhGOThCMyIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PmudzdsAAAEdSURBVHjapFNBaoNQEP0TshBUyEps8AIeIQtvkH0o3ek2tAfoFbLKTgtd5gDBO2ThJUJOEFDrQpvpjOTbIaTYTwYevi++57wZPiCieqSmJh8DgDz6hDcm+Be4OwlRK0Jp2zbCebu4m2H2emAR3OngmbAjsXJd1ywC1ZzwocVhGKrRCFeuI2y4bd/3MUkSLIrie6qzcXsyJ5/F0JA4kHjJfw6CQMVxrOq6noxFkPNBErdsEEWRattWlWWpJmObk5zFDM/zenFvIFvV/GbfgxGJT2zANRjIHd/u/MpBvyPxng2apvk1MNkhibeEpqqqXsxPI4M8z49ksOaI2uS/Mxgqy7JPx3FeLMv6oigXMLmN0jhN06eu697h0ev8I8AAE/qng0hSmjkAAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Table","description":"A datatable"}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"JSON","description":"Table containing the JSON column"}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Input columns","description":"The selected columns will be transformed.","optional":false},{"name":"Row keys","description":"Configure how row keys should be handled in the JSON output.\n","optional":false},{"name":"Row key name","description":"The key name to use when row keys are included as JSON values.","optional":false},{"name":"Column names as paths","description":"When enabled, column names are treated as hierarchical paths using the specified separator.","optional":false},{"name":"Path separator","description":"When column names as paths is enabled, this value will be used to find the keys for JSON columns based on the column names.","optional":false},{"name":"Aggregation direction","description":"Configure how to aggregate the selected columns into JSON.\n","optional":false},{"name":"Remove source columns","description":"When checked, the source columns are removed when the rows are kept. It has no effect for the other aggregation direction options, when all columns are removed.","optional":false},{"name":"Missing values","description":"Configure how missing values should be handled in the JSON output.\n","optional":false},{"name":"Output column name","description":"Name of the resulting JSON column.","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202605291551","bundleName":"JSON related functionality for KNIME","bundleSymbolicName":"org.knime.json","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.json","featureName":"KNIME JSON-Processing","featureVersion":"5.12.0.v202605291551","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*M6ImzgljvpBKaP13"},"frequentSuccessors":[{"id":"*xCgldu0u0nsCPEFk","factoryName":"org.knime.json.node.writer.JSONWriterNodeFactory","probability":0.12406947890818859},{"id":"*zOsWiRPweohTpd8S","factoryName":"org.knime.json.node.output.JSONOutputNodeFactory","probability":0.10918114143920596},{"id":"*jDedZ_onUp4c833B","factoryName":"org.knime.rest.nodes.post.RestPostNodeFactory","probability":0.062034739454094295},{"id":"*zhYELiOdCKD64rlU","factoryName":"org.knime.explorer.nodes.callworkflow.local.CallLocalWorkflowNodeFactory","probability":0.052109181141439205},{"id":"*2xUDt4Z24aku4wiS","factoryName":"org.knime.json.node.totable.JSONToTableNodeFactory","probability":0.04714640198511166},{"id":"*C1zA3UfdJepeh0eb","factoryName":"org.knime.json.node.combine.row.RowCombineJsonNodeFactory","probability":0.03225806451612903},{"id":"*eOn8ibZnxIkY7XhT","factoryName":"org.knime.base.node.preproc.stringmanipulation.StringManipulationNodeFactory","probability":0.02977667493796526},{"id":"*YaMkGnHkmVTd6ZB-","factoryName":"org.knime.mongodb.write.MongoDBWriterNodeFactory","probability":0.02977667493796526},{"id":"*xDQ1LJvJiHYRxkHK","factoryName":"com.knime.server.nodes.callworkflow.CallRemoteWorkflowNodeFactory","probability":0.02977667493796526},{"id":"*3IccdLfpFEAp9yoz","factoryName":"org.knime.json.node.jsonpath.multi.JSONPathNodeFactory","probability":0.02729528535980149}]}