Combines JSON values to a single JSON value (an array optionally wrapped in an object) for each row. Example configuration:\n \n Input table:\n \n
SRV2[1]"S"3{"a":2}{"T": null}\n Selected JSON columns: R and V\n \n Data bound key: S (String)\n \n Results:\n {"2": [[1], "S"]}{"3": [{"a": 2}, {"T": null}]}\n ","shortDescription":"Combines multiple JSON columns to a single.","keywords":[],"deprecated":false,"streamable":true,"tags":["Structured Data","JSON","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyhpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMTExIDc5LjE1ODMyNSwgMjAxNS8wOS8xMC0wMToxMDoyMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6M0FDQURGM0FFRjUwMTFFNUJCQTVFNkU1RjA4Rjk4QjMiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6Q0NBNDY1QjZFRjUwMTFFNUJCQTVFNkU1RjA4Rjk4QjMiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDozQUNBREYzOEVGNTAxMUU1QkJBNUU2RTVGMDhGOThCMyIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDozQUNBREYzOUVGNTAxMUU1QkJBNUU2RTVGMDhGOThCMyIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pnis/Q4AAAHNSURBVHjapFPLasJQEJ3UJsYHKogiFHQhCAVtN/oH7nysxFVd5AfEtVCw0E/wC0RcWIhbwY1/YBdSIeBGEBcKPhCCz3TulITYZGdgyJ07Z8487gwHABrYfJqmcWad4zhbHPeHvbUh2JbADvf4n1FVVfqLovjt9/ufY7HYNZ1Oj8vlMlwuF3A4HDf4B7Mym80gk8mA0+kEdH5FETCqqChKOhQKQbvdht1uZ18Ci4yRYDqdMmcIBAIQDAbB7XaTziQejxN5tVoFQRCoBCODZrNpOEuSBK1WS63X65+of+gEp9MJ5vM59Pt9awndbpdAhUIBSqUS7Pf7Hp7fZVlu4P0Xs3m9XthutzAYDKwEi8WCCLLZLIFQZN2G9z1Wkk6APbES+Hw+IvB4PDqBAUJnjdmOxyPdmxtpEKRSKSLQnVFypgxyLMBoNCIba67+GXNQLBYB64XVakU6AqVarTZJJpM8dvxtOBzCeDwmgkqlYn3Gw+EAjUYDeJ6nYdlsNnq6Vzw/6JmFw2Fqosvlome8GeX1eg2dTocGarlcmsshiUQiNEzRaNQYZcsunM9nyOfzkEgklMlk8oTRnej8g+//wspjkc27cPcycfeu868AAwDNIgGiBAb7QQAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Table with JSON","description":"Table with JSON column(s)"}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Table with JSON","description":"Table with the combined 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":"New column name","description":"Name of the new JSON column","optional":false},{"name":"Remove source columns","description":"When checked, the included columns and the data bound key/value columns will be removed from the resulting table","optional":false},{"name":"Root key type","description":"How to create the root of the JSON value: Unnamed root elements generate JSON without a wrapping key, Custom key uses a constant key for all rows, Data bound key uses a column value from each row as the key\n
Unamed root elements : Generate JSON without a wrapping key.
Custom key : Use a constant key for all rows.
Data bound key : Use a column value from each row as the key.
","optional":false},{"name":"Custom key name","description":"The constant key for the array of JSON values selected (Selected JSON columns)","optional":false},{"name":"Data bound key column","description":"The column name, whose values become the key for the array of JSON values selected (Selected JSON columns)","optional":false},{"name":"Selected JSON columns","description":"The included columns will be combined to a new JSON value for each row","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":"*zOsWiRPweohTpd8S","factoryName":"org.knime.json.node.output.JSONOutputNodeFactory","probability":0.1111111111111111},{"id":"*xCgldu0u0nsCPEFk","factoryName":"org.knime.json.node.writer.JSONWriterNodeFactory","probability":0.08333333333333333},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.05555555555555555},{"id":"*C1zA3UfdJepeh0eb","factoryName":"org.knime.json.node.combine.row.RowCombineJsonNodeFactory","probability":0.05555555555555555},{"id":"*2xUDt4Z24aku4wiS","factoryName":"org.knime.json.node.totable.JSONToTableNodeFactory","probability":0.05555555555555555},{"id":"*6CbObXLq9oHq_EFi","factoryName":"org.knime.base.node.preproc.constantvalue.ConstantValueColumnNodeFactory","probability":0.027777777777777776},{"id":"*6jI6GPZYQlWirx9J","factoryName":"org.knime.base.node.viz.table.TableNodeFactory","probability":0.027777777777777776},{"id":"*7N4LxTHoPJrHN5lT","factoryName":"org.knime.base.node.stats.viz.extended.ExtendedStatisticsNodeFactory","probability":0.027777777777777776},{"id":"*AApA5VHd41CVDe7u","factoryName":"org.knime.base.node.meta.looper.LoopEndNodeFactory","probability":0.027777777777777776},{"id":"*AB2v7bC0nru1GHKf","factoryName":"org.knime.json.node.toxml.JSONToXMLNodeFactory","probability":0.027777777777777776}]}