{"title":"Column Name Extractor","nodeType":"Manipulator","id":"*dFOX6ADqOFSQJtqe","factoryName":"org.knime.base.node.preproc.columnheaderextract.ColumnHeaderExtractorNodeFactory","factoryId":"org.knime.base.node.preproc.columnheaderextract.ColumnHeaderExtractorNodeFactory","path":["Manipulation","Row","Other"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Creates a new table with a single row or column containing the column names. The node has two output tables: The first table contains the column headers (all columns are of type string), either as a single row containing all headers or as one row per header. The second table contains the input data, whereby the column names are changed to a default pattern (given that the corresponding option is set.)</p>\n        ","shortDescription":"Creates a new table with a single row or column containing the column names of the input table.","keywords":["Column header to row","Column names"],"deprecated":false,"streamable":true,"tags":["Manipulation","Row","Other","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3hpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6ODlGNDhDMjIxNjhDMTFFNUJEOTVBMUI1OTFFQzZGQkIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6ODlGNDhDMjExNjhDMTFFNUJEOTVBMUI1OTFFQzZGQkIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDplYjRlYWE5NS1mMzM5LTQzZTctYmY1Yy0yNzFmOThkY2ZiMmIiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6MGIzNmFjOTctNWViYS00MGU3LTkxODktYmJlOGQ3ZDBmMjRlIi8+IDwvcmRmOkRlc2NyaXB0aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+ZC9NPgAAAI1JREFUeNrEUgEKgCAQu4v+UGT//1pR9ALNy6MUMyvLoIEig43bubKpBIEHrTX0YweGd5xUEsZp2HEObBDC0EkcawvIxP8GJV+ibh2xxt1zalYHzgKtICsCIr42YCWdTWJGvu0IbAY2u3vzSelI7BfoSaTCE1E4Veo3YkSIj3oQWay/yMuOfNODHCwCDADApIu6XEVTwgAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input data","description":"Original input data"}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Column Header Table","description":"Table with single row or column containing original column names"},{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input table with replaced column header","description":"Input table with either original or changed 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":[{"fields":[{"name":"Generate new column names","description":"If selected, the column names of both output tables will be replaced with automatically generated names by combining the prefix provided below with the corresponding column number (e.g. &#34;Column 1&#34;, &#34;Column 2&#34;, and so on). Otherwise, the original column names will be used.","optional":false},{"name":"Prefix","description":"Prefix to use when generating new column names","optional":false},{"name":"Output format for column names","description":"The format in which the first output table provides the extracted column names:\n<ul><li><b>Row</b> : The column names are output as a single row with a column per name.</li><li><b>Column</b> : The column names are output as a single column with a row per name.</li></ul>","optional":false},{"name":"Restrain column types","description":"Select the type of the columns to extract the names from:\n<ul><li><b>All</b> : All columns are processed.</li><li><b>String</b> : Only string-compatible columns are processed, this includes e.g. XML columns.</li><li><b>Integer</b> : Only integer-compatible columns are processed.</li><li><b>Double</b> : Only double-compatible columns are processed. This includes integer and long columns.</li></ul>","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:751e2226-1074-4bf6-b7af-29a0c091d977","user":"gimbo","date":"2021-02-22T14:27:49+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":"*rqhXsa-dMez9coq4","factoryName":"org.knime.base.node.preproc.transpose.TransposeTableNodeFactory","probability":0.30403800475059384},{"id":"*jcLGoxXUmUY4lE6u","factoryName":"org.knime.base.node.preproc.columnheaderinsert.ColumnHeaderInsertNodeFactory","probability":0.15518606492478226},{"id":"*0rhLXWO6OS1xMi8T","factoryName":"org.knime.base.node.preproc.append.row.AppendedRowsNodeFactory","probability":0.08076009501187649},{"id":"*OFhUBYYlMMQ7ZM3F","factoryName":"org.knime.base.node.flowvariable.tablerowtovariable.TableToVariableNodeFactory","probability":0.04275534441805225},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.03483768804433888},{"id":"*eOn8ibZnxIkY7XhT","factoryName":"org.knime.base.node.preproc.stringmanipulation.StringManipulationNodeFactory","probability":0.02454473475851148},{"id":"*OrsWDmrgrJ2VEX6h","factoryName":"org.knime.base.node.preproc.unpivot2.Unpivot2NodeFactory","probability":0.02454473475851148},{"id":"*PHWv6FsABEjrSc76","factoryName":"org.knime.base.node.preproc.rename.RenameNodeFactory","probability":0.01741884402216944},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.014251781472684086},{"id":"*VU5C_Qbl6sDSPXjl","factoryName":"org.knime.base.node.flowvariable.tablecoltovariable.TableColumnToVariableNodeFactory","probability":0.013460015835312747}]}
