{"title":"Ungroup","nodeType":"Manipulator","id":"*aItro4n6xSMUuxg-","factoryName":"org.knime.base.node.preproc.ungroup.UngroupNodeFactory","factoryId":"org.knime.base.node.preproc.ungroup.UngroupNodeFactory","path":["Manipulation","Row","Transform"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Creates for each list of collection values a list of rows with the values of the collection in one column and all other columns given from the original row. Rows with an empty collection are skipped, as well as rows that contain only missing values in the collection cell with the &#39;Skip missing values&#39; option enabled.</p>\n        ","shortDescription":"Creates for each list of collection values a list of rows with the values of the collection in\none column and all other columns given from the original row.","keywords":["ungroup","expand","collection","list","set"],"deprecated":false,"streamable":true,"tags":["Manipulation","Row","Transform","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3hpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6RTJBODlBQ0ExNjhDMTFFNUJEOTVBMUI1OTFFQzZGQkIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6RTJBODlBQzkxNjhDMTFFNUJEOTVBMUI1OTFFQzZGQkIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDplYjRlYWE5NS1mMzM5LTQzZTctYmY1Yy0yNzFmOThkY2ZiMmIiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6MGIzNmFjOTctNWViYS00MGU3LTkxODktYmJlOGQ3ZDBmMjRlIi8+IDwvcmRmOkRlc2NyaXB0aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+PS0yJgAAADNJREFUeNpiYsANHgDxf0KYiYFCMPAGsJCglpFmLvg/tAORKgYw4sAPB106+D9MYwEgwAAv9Qzk4H6cxQAAAABJRU5ErkJggg==","sinceVersion":"5.8.0","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Data table","description":"The input table to ungroup"}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Data table","description":"Ungrouped table"}],"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":"Collection columns to ungroup","description":"Select the collection columns that should be ungrouped.","optional":false},{"name":"Remove selected collection column","description":"If enabled, the selected collection column will be removed from the result table. If disabled, the original collection column will be kept in the output alongside the ungrouped values.","optional":false},{"name":"Skip missing values","description":"If enabled, rows with a missing value in all selected collection columns are skipped, as well as missing values in a collection cell if they occur in all selected collection columns.","optional":false},{"name":"Skip empty collections","description":"If enabled, rows in which all selected collection columns are empty will be skipped.","optional":false},{"name":"Enable hiliting","description":"If enabled, the hiliting of an input row results in hiliting all rows (given in the collection cell) of the ungrouped output table. Conversely, if all output rows (represented in one or more collection cells) are highlighted, the input row(s) are highlighted as well. Depending on the number of rows, enabling this feature might consume a lot of memory.","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606261225","bundleName":"KNIME Base Nodes","bundleSymbolicName":"org.knime.base","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.base","featureName":"KNIME Base nodes","featureVersion":"5.12.0.v202606261225","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*bjR3r1yWOznPIEXS"},"frequentSuccessors":[{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.11116965226554268},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.09272918861959958},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.08798735511064278},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.06533192834562697},{"id":"*3IccdLfpFEAp9yoz","factoryName":"org.knime.json.node.jsonpath.multi.JSONPathNodeFactory","probability":0.06217070600632244},{"id":"*2xUDt4Z24aku4wiS","factoryName":"org.knime.json.node.totable.JSONToTableNodeFactory","probability":0.03898840885142255},{"id":"*eOn8ibZnxIkY7XhT","factoryName":"org.knime.base.node.preproc.stringmanipulation.StringManipulationNodeFactory","probability":0.037934668071654375},{"id":"*dTIN1LNlL6w1s7MX","factoryName":"org.knime.xml.node.xpath2.XPathNodeFactory","probability":0.03371970495258166},{"id":"*LKxrCJihG46anH0Q","factoryName":"org.knime.base.node.preproc.filter.rowref.RowFilterRefNodeFactory","probability":0.02423603793466807},{"id":"*PHWv6FsABEjrSc76","factoryName":"org.knime.base.node.preproc.rename.RenameNodeFactory","probability":0.023182297154899896}]}