{"title":"Split Collection Column","nodeType":"Manipulator","id":"*GyRUByJzWSm3AXGk","factoryName":"org.knime.base.collection.list.split.CollectionSplitNodeFactory","factoryId":"org.knime.base.collection.list.split.CollectionSplitNodeFactory","path":["Manipulation","Column","Split & Combine"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node splits a column containing a collection of cells into its sub-components. If a row contains more elements than implied by the various options (see below), the remaining elements are ignored. If it contains less elements than expected, the remaining columns are filled with missing values.</p>\n        ","shortDescription":"Splits a collection column into its sub components, adding one new column for each.","keywords":[],"deprecated":false,"streamable":false,"tags":["Manipulation","Column","Split & Combine"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3hpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6RTQ3QjA0MkIxODM0MTFFNTgxM0FFMEQwQTc0Qzg5QTIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6RTQ3QjA0MkExODM0MTFFNTgxM0FFMEQwQTc0Qzg5QTIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpjZTBmYzg4ZC1kNjkyLTQ5NDEtOTZiOC03ODIxMjliYWZkYWIiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6MGIzNmFjOTctNWViYS00MGU3LTkxODktYmJlOGQ3ZDBmMjRlIi8+IDwvcmRmOkRlc2NyaXB0aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+YbLDPwAAAKtJREFUeNqkU1EOwjAIBeTPC5hscd7/Vpp4g33406IkQ1vClMaXkG5rebxHGUMCIgLnaVlLKUe/x5AEER1u92v3bTrNwMoeARFzxK+DohEkyRbfCT4F0ftOSaBAusAAPMFQ8vsWtJFtZadCzF5r05pP8Ccoapo+N++64jJfHlrVoiNQaZs8HJmBPQsYjfIvArFDJjF7ney8d4OUscIjfnfnIINaa9G/z+MpwAAi2E4Q7TCdmAAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Data with collection column","description":"Input data with collection column to split."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input data with newly appended columns","description":"The input data along with newly appended columns."}],"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":"Column selection","description":"Select the column containing the collection value.","optional":false},{"name":"Replace input column","description":"Select this when the column containing the collection is to be removed from the output.","optional":false},{"name":"Determine most specific type","description":"The collection column often contains only general type information to the individual elements. Selecting this option will determine the most specific type of the newly appended columns based on the actual content. If unsure, keep this option selected.","optional":false},{"name":"Element count policy","description":"Select the policy on how to determine how many elements the input column contains.\n<ul><li><b>Best effort</b> : Try to use the information from the input table; if none is available, count the occurrences.</li><li><b>Use input table information</b> : Use the &#34;element names&#34; field in the collection column. This information may not always be present in the input table, in which case the node will fail its execution. The column names are defined by the element names.</li><li><b>Count in advance</b> : Perform one additional scan on the table and count the occurrences. The names of the new columns are auto-generated.</li></ul>","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":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.09305373525557012},{"id":"*PHWv6FsABEjrSc76","factoryName":"org.knime.base.node.preproc.rename.RenameNodeFactory","probability":0.061598951507208385},{"id":"*OrsWDmrgrJ2VEX6h","factoryName":"org.knime.base.node.preproc.unpivot2.Unpivot2NodeFactory","probability":0.04980340760157274},{"id":"*_3lbfRYUi6sJ5AQm","factoryName":"org.knime.base.node.preproc.colcombine2.ColCombine2NodeFactory","probability":0.04325032765399738},{"id":"*rqhXsa-dMez9coq4","factoryName":"org.knime.base.node.preproc.transpose.TransposeTableNodeFactory","probability":0.04325032765399738},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.03145478374836173},{"id":"*wiIVn14C9BeYBHqr","factoryName":"org.knime.base.node.preproc.columnaggregator.ColumnAggregatorNodeFactory","probability":0.03014416775884666},{"id":"*1Uo48m8MIHW-seLx","factoryName":"org.knime.base.node.preproc.rowkey2.RowKeyNodeFactory2","probability":0.02490170380078637},{"id":"*GyRUByJzWSm3AXGk","factoryName":"org.knime.base.collection.list.split.CollectionSplitNodeFactory","probability":0.022280471821756225},{"id":"*v2rCBWb37Ywxh2AG","factoryName":"org.knime.base.node.preproc.columnrenameregex.ColumnRenameRegexNodeFactory","probability":0.022280471821756225}]}
