{"title":"Unpivot","nodeType":"Manipulator","id":"*OrsWDmrgrJ2VEX6h","factoryName":"org.knime.base.node.preproc.unpivot2.Unpivot2NodeFactory","factoryId":"org.knime.base.node.preproc.unpivot2.Unpivot2NodeFactory","path":["Manipulation","Row","Transform"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node rotates the selected columns from the input table to rows and duplicates at the same time the remaining input columns by appending them to each corresponding output row. Example:</p><pre>Input:\n\tValue1 Value2 Value3 Extra1 Extra2 Extra3\nOutput:\n\tValue1 Extra1 Extra2 Extra3\n\tValue2 Extra1 Extra2 Extra3\n\tValue3 Extra1 Extra2 Extra3\n\t\t\t</pre>\n            \t\t\n        \n        ","shortDescription":"This node rotates the selected columns from the input table to rows and duplicates\n\t\tat the same time the remaining input columns by appending them to each corresponding output row.","keywords":["melt","wide to long table"],"deprecated":false,"streamable":false,"tags":["Manipulation","Row","Transform"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6REEzQzk4NjE4OUVBMTFFNTkyQzJBQjlCNTFCMUUyMzIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6REEzQzk4NjA4OUVBMTFFNTkyQzJBQjlCNTFCMUUyMzIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpCRjcxMDcwOTE2OEMxMUU1QkQ5NUExQjU5MUVDNkZCQiIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDpCRjcxMDcwQTE2OEMxMUU1QkQ5NUExQjU5MUVDNkZCQiIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PmNb5QAAAABlSURBVHjaYmFgYPivKKf0kwELuP/oHjsDAcAIMgAIGMgBjIyMDEwMFIKBN4AF5hdKDCBW9/+Pk61RBPhzjw6SQPw/KKPxPzVc8J/odIBH8X9C0YwrHfxHymwEcyOxNmN1JUCAAQCtcBUmto1fcAAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Data table","description":"Input table with at least one value column for the unpivoting operation."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Unpivoting table","description":"Unpivoting table with duplicated columns together with rotated value columns and their corresponding column names."}],"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":"Value columns","fields":[{"name":"Include/exclude columns","description":"This list contains the columns that are rotated into one single column.\n<br />\n<b>Manual selection</b>:\n<ul><li><i>Buttons</i> : Use these buttons to move columns between the Include and Exclude list. Single-arrow buttons will move all selected columns. Double-arrow buttons will move all columns (filtering is taken into account).</li><li><i>Any unknown columns</i> : Controls what happens with new columns when the input table changes. If this placeholder is in the include list, then new columns are included, otherwise they are excluded.</li></ul>\n<br />\n<b>Wildcard/Regex</b>:\n<ul><li><i>Pattern</i> : Type a search pattern which matches columns to move into the Include or Exclude list. Which list is used can be specified. You can use either Wildcards (&#39;?&#39; matching any character, &#39;*&#39; matching a sequence of any characters) or Regex. You can specify whether your pattern should be case sensitive and whether the pattern defines the includes or the excludes.</li></ul>\n<br />\n<b>Types</b>:\n<ul><li><i>Selected types</i> : Select the column types that you want to include.</li></ul>","optional":false},{"name":"Skip rows containing missing cells","description":"Skip all rows containing missing cells in the selected value column(s).","optional":false}]},{"sectionName":"Retained columns","fields":[{"name":"Include/exclude columns","description":"This list contains the columns which are duplicated by the number of selected value columns.\n<br />\n<b>Manual selection</b>:\n<ul><li><i>Buttons</i> : Use these buttons to move columns between the Include and Exclude list. Single-arrow buttons will move all selected columns. Double-arrow buttons will move all columns (filtering is taken into account).</li><li><i>Any unknown columns</i> : Controls what happens with new columns when the input table changes. If this placeholder is in the include list, then new columns are included, otherwise they are excluded.</li></ul>\n<br />\n<b>Wildcard/Regex</b>:\n<ul><li><i>Pattern</i> : Type a search pattern which matches columns to move into the Include or Exclude list. Which list is used can be specified. You can use either Wildcards (&#39;?&#39; matching any character, &#39;*&#39; matching a sequence of any characters) or Regex. You can specify whether your pattern should be case sensitive and whether the pattern defines the includes or the excludes.</li></ul>\n<br />\n<b>Types</b>:\n<ul><li><i>Selected types</i> : Select the column types that you want to include.</li></ul>","optional":false}]},{"sectionName":"Performance","fields":[{"name":"Enable hiliting","description":"Advanced setting that if selected enables hiliting between input and output data.","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:3784265b-0f76-45f2-9a61-e472e4206f70","user":"nimantha","date":"2021-02-09T08:35:48+00:00"}],"kudosCount":1,"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":"*PHWv6FsABEjrSc76","factoryName":"org.knime.base.node.preproc.rename.RenameNodeFactory","probability":0.14398595258999122},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.11589113257243196},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.0996488147497805},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.06584723441615452},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.06540825285338016},{"id":"*eOn8ibZnxIkY7XhT","factoryName":"org.knime.base.node.preproc.stringmanipulation.StringManipulationNodeFactory","probability":0.048287971905179985},{"id":"*ebLbPp7VLbV4apta","factoryName":"org.knime.base.node.preproc.pivot.Pivot2NodeFactory","probability":0.036435469710272166},{"id":"*IPAOkJNeJy0B8rPZ","factoryName":"org.knime.base.node.preproc.cellsplit.CellSplitterNodeFactory","probability":0.028094820017559263},{"id":"*Q-yW-3C9DumtInuz","factoryName":"org.knime.base.node.rules.engine.RuleEngineFilterNodeFactory","probability":0.02502194907813872},{"id":"*zpGPAjDyExkFL2HB","factoryName":"org.knime.base.node.rules.engine.RuleEngineNodeFactory","probability":0.02151009657594381}]}