{"title":"Pivot","nodeType":"Manipulator","id":"*ebLbPp7VLbV4apta","factoryName":"org.knime.base.node.preproc.pivot.Pivot2NodeFactory","factoryId":"org.knime.base.node.preproc.pivot.Pivot2NodeFactory","path":["Manipulation","Row","Transform"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Performs a pivoting on the given input table using a selected number of columns for grouping and pivoting. The group columns will result into unique rows, whereby the pivot values turned into columns for each set of column combinations together with each aggregation method. In addition, the node returns the total aggregation (a) based on only the group columns and (b) based on only the pivoted columns resulting in a single row; optionally, with the total aggregation without pivoting.</p>\n            \n        \n        ","shortDescription":"Pivots and groups the input table by the selected columns for pivoting and grouping; enhanced by column\n    aggregations.","keywords":["Cross tab","long to wide table"],"deprecated":false,"streamable":false,"tags":["Manipulation","Row","Transform"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6RjU5OUYxMjA4OUU4MTFFNTkyQzJBQjlCNTFCMUUyMzIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6RjU5OUYxMUY4OUU4MTFFNTkyQzJBQjlCNTFCMUUyMzIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpENEQ0NDE1RTE2OEMxMUU1QkQ5NUExQjU5MUVDNkZCQiIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDpENEQ0NDE1RjE2OEMxMUU1QkQ5NUExQjU5MUVDNkZCQiIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PmpxyP8AAABsSURBVHjaYmFgYPjPQAFgARH//6OawcjIyPBxsjVBzfy5RxmYGCgEA28AIyQIMMOApEDEBoCByEipCxhpGQZwS8kx4D/UlWBDmMjRjOTV/0wkuhtkLSMye+ATEgtJqQ5LAmMhMuXhzPIAAQYAZTwo39tDE8MAAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Data table","description":"The input table to pivot."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Pivot table","description":"Pivot table."},{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Group totals","description":"A table containing the totals for each defined group. That is, the aggregation for each group ignoring the pivoting groups. This table can be joined with the Pivot table; the RowIDs of both tables represent the same groups). The table will contain as many rows as there are different groups in the data and as many columns as there are selected aggregations. The table is identical to the output of a GroupBy node, in which the group and aggregation columns are chosen accordingly."},{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Pivot totals","description":"A single row table containing the aggregated values of the Pivot table. The table structure is identical to the Pivot table (possibly enriched by overall totals if the &#34;Append overall totals&#34; is selected. This table is usually concatenated with table that results from joining the Pivot table with the Group 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":"Group columns","description":"Select one or more columns according to which the group rows are created.","optional":false},{"name":"Pivot columns","description":"Select one or more columns according to which the pivot columns are created.","optional":false},{"name":"Ignore missing values","description":"Ignore rows containing missing values in pivot column.","optional":false},{"name":"Append overall totals","description":"Appends the overall pivot totals with each aggregation performed together on all selected pivot columns.","optional":false},{"name":"Ignore domain","description":"Ignore domain and use only the possible values available in the input data.","optional":false},{"name":"Manual Aggregations","description":"Select one or more column(s) for aggregation from the available columns list. Change the aggregation method in the Aggregation column of the table. You can add the same column multiple times.\n<ul><li><b>Column</b> : The column to aggregate</li><li><b>Aggregation</b> : The aggregation method to use</li><li><b>Missing values</b> : Missing values are considered during aggregation if the missing option set to &#34;Included&#34;. Some aggregation methods do not support the changing of the missing option such as &#34;Mean&#34;.</li></ul>","optional":false},{"name":"Column name","description":"The name of the resulting pivot column(s) depends on the selected naming schema.\n<ul><li><b>Pivot name&#43;Aggregation name</b> : Uses the pivot name first and the aggregation name second joint by a &#39;&#43;&#39; character. Keeps the original column names. Note that you can use all aggregation columns only once with this column naming option to prevent duplicate column names.</li><li><b>Aggregation name&#43;Pivot name</b> : Uses the aggregation name first and the pivot name second joint by a &#39;&#43;&#39; character.</li><li><b>Pivot name</b> : Uses solely the pivot name. Note that this option solely supports the selection of a single aggregation method to ensure uniqueness of the column names.</li></ul>","optional":false},{"name":"Aggregation name","description":"The name of the resulting aggregation column(s) depends on the selected naming schema.\n<ul><li>Keep original name(s): Keeps the original column names. Note that you can use all aggregation columns only once with this column naming option to prevent duplicate column names.</li><li>Aggregation method (column name): Uses the aggregation method first and appends the column name in brackets</li><li>Column name (aggregation method): Uses the column name first and appends the aggregation method in brackets</li></ul>\nAll aggregation methods get a * appended if the missing value option is not ticked in the aggregation settings in order to distinguish between columns that considered missing values in the aggregation process and columns that do not.","optional":false},{"name":"Maximum unique values per group","description":"Defines the maximum number of unique values per group to avoid problems with memory overloading. All groups with more unique values are skipped during the calculation and a missing value is set in the corresponding column, and a warning is displayed.","optional":false},{"name":"Value delimiter","description":"The value delimiter used by aggregation methods such as concatenate.","optional":false},{"name":"Sort lexicographically","description":"Lexicographically sorts all columns belonging to the same logical group, i.e., pivots (aggregations), groups, and overall totals.","optional":false},{"name":"Enable hiliting","description":"If enabled, the hiliting of a group row will hilite all rows of this group in other views. Depending on the number of rows, enabling this feature might consume a lot of memory.","optional":false},{"name":"Process in memory","description":"Process the table in the memory. Requires more memory but is faster since the table needs not to be sorted prior aggregation. The memory consumption depends on the number of unique groups and the chosen aggregation method. The row order of the input table is automatically retained.","optional":false},{"name":"Retain row order","description":"Retains the original row order of the input table. Could result in longer execution time. The row order is automatically retained if the process in memory option is selected.","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:751e2226-1074-4bf6-b7af-29a0c091d977","user":"gimbo","date":"2021-02-22T13:58:41+00:00"},{"accountId":"account:user:0e09e6ba-9798-4a46-b08f-7525750234ac","user":"zfuak","date":"2021-06-10T05:41:20+00:00"},{"accountId":"account:user:6106d810-f9f5-409c-875a-5ccd26ac95c9","user":"mbarbasm","date":"2023-05-24T20:06:16+00:00"},{"accountId":"account:user:498b0732-17cb-40a8-bc35-fccbe94ac93e","user":"nborbas","date":"2023-04-27T09:00:37+00:00"},{"accountId":"account:user:1933e596-cfb7-4968-b3ec-033a2ac11061","user":"carlos_estrela","date":"2022-04-12T15:17:16+00:00"}],"kudosCount":5,"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":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.13369169412172707},{"id":"*uVmaGQkzUOFCTqUe","factoryName":"org.knime.base.node.preproc.pmml.missingval.compute.MissingValueHandlerNodeFactory","probability":0.08704699150338131},{"id":"*v2rCBWb37Ywxh2AG","factoryName":"org.knime.base.node.preproc.columnrenameregex.ColumnRenameRegexNodeFactory","probability":0.07577596670712676},{"id":"*PHWv6FsABEjrSc76","factoryName":"org.knime.base.node.preproc.rename.RenameNodeFactory","probability":0.06901335182937403},{"id":"*2fI5rIsFDCFPHc0R","factoryName":"org.knime.ext.jep.JEPNodeFactory","probability":0.05306051673313681},{"id":"*JiJhJpgkWWuOfG2s","factoryName":"org.knime.ext.poi2.node.write2.XLSWriter2NodeFactory","probability":0.04924570834055835},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.03277267209987862},{"id":"*Oy714gpoifm4PiOZ","factoryName":"org.knime.base.node.io.csvwriter.CSVWriterNodeFactory","probability":0.031732269810993585},{"id":"*6k1xlCi486vumV3V","factoryName":"org.knime.base.node.preproc.columnresorter.ColumnResorterNodeFactory","probability":0.03069186752210855},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.029304664470261834}]}