{"title":"Column to Grid","nodeType":"Manipulator","id":"*MyUFTQuDjqnjlyto","factoryName":"org.knime.base.node.preproc.columntogrid2.ColumnToGrid2NodeFactory","factoryId":"org.knime.base.node.preproc.columntogrid2.ColumnToGrid2NodeFactory","path":["Manipulation","Column","Split & Combine"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Breaks a selected column (or set of columns) into new columns, such that they align in a grid. This is useful for displaying, for instance a column containing images in a grid that can then be shown in a report table. The number of grid columns is to be set in the dialog, the number of rows is determined accordingly.</p>\n        ","shortDescription":"Breaks a selected column (or set of columns) into new columns, such that they align in a grid.","keywords":[],"deprecated":false,"streamable":false,"tags":["Manipulation","Column","Split & Combine"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6NTNDQTZGM0E4N0JEMTFFNUIyNjBENUZBOEI3RjgwMEUiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6NTNDQTZGMzk4N0JEMTFFNUIyNjBENUZBOEI3RjgwMEUiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpGQTlGNjExRTE4MzQxMUU1ODEzQUUwRDBBNzRDODlBMiIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDpGQTlGNjExRjE4MzQxMUU1ODEzQUUwRDBBNzRDODlBMiIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PrBalJgAAACbSURBVHjatFJLEoAgCAXHXYsO1Jk6TWfqQG3amjjiEGKfsd4MAg9TfOEAIFgWQQs06glU9xRsywQS47wmj4jJwRlBJg46gfpEVSutFhKREmTO6w2idZ3LTYG4+B26l91W+VsNhuw96ECj8aydb+b6ZQckGJueBeZvnyAGyoy75+CbA0ggaVo85qzY5amq7KkG3po86zf+psEhwAAonG4S4gUUJQAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Table with column(s) to align in grid","description":"Table with one or more columns to be displayed in a grid"}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Grid table","description":"Table with selected column(s) in a grid"}],"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":"Grid column count","description":"The number of grid columns, this should be a relatively small number.","optional":false},{"name":"Columns to include","description":"Select the column(s) that are to be displayed in a grid. If multiple columns are selected, the entire set will constitute a grid column.","optional":false},{"name":"Group column","description":"Select this option and choose a group column in order to separate input rows that do not belong to the same group. This is useful when visualizing, e.g. clustering results, whereby records from different clusters are represented by different output rows. The group column will be another column in the output table.","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":"*JiJhJpgkWWuOfG2s","factoryName":"org.knime.ext.poi2.node.write2.XLSWriter2NodeFactory","probability":0.07207207207207207},{"id":"*PHWv6FsABEjrSc76","factoryName":"org.knime.base.node.preproc.rename.RenameNodeFactory","probability":0.04504504504504504},{"id":"*AApA5VHd41CVDe7u","factoryName":"org.knime.base.node.meta.looper.LoopEndNodeFactory","probability":0.04504504504504504},{"id":"*XbOgJJl-gFiDMtr1","factoryName":"org.knime.base.node.preproc.columntrans2.Many2OneCol2NodeFactory","probability":0.04504504504504504},{"id":"*rqhXsa-dMez9coq4","factoryName":"org.knime.base.node.preproc.transpose.TransposeTableNodeFactory","probability":0.036036036036036036},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.036036036036036036},{"id":"*NmCHLnBIGbvnDkb6","factoryName":"org.knime.base.node.meta.looper.columnlist2.ColumnListLoopStartNodeFactory","probability":0.036036036036036036},{"id":"*VU5C_Qbl6sDSPXjl","factoryName":"org.knime.base.node.flowvariable.tablecoltovariable.TableColumnToVariableNodeFactory","probability":0.02702702702702703},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.02702702702702703},{"id":"*0rhLXWO6OS1xMi8T","factoryName":"org.knime.base.node.preproc.append.row.AppendedRowsNodeFactory","probability":0.018018018018018018}]}