{"title":"Table Manipulator","nodeType":"Manipulator","id":"*GV0dF7NgDOyLFMsK","factoryName":"org.knime.base.node.preproc.manipulator.TableManipulatorNodeFactory","factoryId":"org.knime.base.node.preproc.manipulator.TableManipulatorNodeFactory","path":["Manipulation","Column"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Allows to perform several column transformations on any number of input tables such as renaming, filtering, re-ordering and type changing of the input columns.</p><p>If more than one input table is available the node concatenates all input rows into a single result table. If the input tables contain the same RowID the node can either generate a new RowID or prepend the input table index to the original RowID of the corresponding input table.</p>\n            \n        \n        ","shortDescription":"Allows to perform several transformations on any number of input tables such as renaming, filtering,\n    re-ordering and type changing of the input columns. If more than one input table is available the\n    node concatenates all input rows into a single result table.","keywords":[],"deprecated":false,"streamable":true,"tags":["Manipulation","Column","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAAOxAAADsQBlSsOGwAAABl0RVh0U29mdHdhcmUAd3d3Lmlua3NjYXBlLm9yZ5vuPBoAAAFbSURBVDiNpZCxS0JRGMV/r16E+GyI1sQGcRQEaypobXVolyantsCppcXJSTQf+gf0L7TUGxwywwaFaBAeEUUEUs+uvp635T25RNQLD1y453zfd757j6aBjEV0wkBKietJIdxpJND0WETHLm2FMngcTtg8udGEO51pC6Emf8HcBtrigibT69FQzZ+e5P75Q4wmSgbeVHJwVBoEQqFQSFQqlQFAt9sdNpvNtXK57Ab8tlZb+m4sVajcsqy+YRh9lQPX6vDcGegA8Xj8StGyAXccZ9lxnITKAQ04A2rAuQbIRqMxM8jn89mAt9vtkWmaG9Vq9Qmg1WqJer2eBlaAEbAbOgMhhMxkMm+A9M8FEA2VwXg8JpfL0el0DF+6BPYARwcoFouW0r8d8F6v5wkhUslk8tW27VW//h4M4wdy+scDdoCUf38ATOA4KGohfnAHuMCLuvk/OAT2gchPxS8FSshEmoXeNAAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Table 0","description":"Table to manipulate"}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Appended table","description":"A table with the transformed columns from all input tables (Table 0, Table 1, Table ...)"}],"dynInPorts":[{"groupName":"input","groupDescription":"Table(s) contributing subsequent rows and columns.","types":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table"}]}],"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":"Use existing RowID","description":"Check this box if the RowIDs from the input tables should be used for the output tables.If unchecked, a new RowID is generated. The generated RowID follows the schema &#34;Row0&#34;, &#34;Row1&#34; and so on.","optional":false},{"name":"Prepend table index to RowID","description":"Only enabled if the existing RowIDs are used. If checked, a prefix is prepended to the RowIDs that indicates which table the row came from. The format of the prefix is &#34;Table_0_&#34;, &#34;Table_1_&#34;, and so on.","optional":false},{"name":"Take columns from","description":"Only relevant when several input tables are available. Specifies which set of columns is considered for the output table.\n<br />\n<b>Note:</b>\n<br />\nThis setting has special implications if you are changing the input table without reconfiguring the node. If <i>Intersection</i> is selected, any column that moves into the intersection during execution will be considered to be new, even if it was previously part of the union of columns.\n<ul><li><b>Union</b> : Any column that is part of any input table is considered. If an input table is missing a column, it is filled up with missing values.</li><li><b>Intersection</b> : Only columns that appear in all input tables are considered for the output table.</li></ul>","optional":false},{"name":"Enforce types","description":"Controls how columns whose type changes are dealt with. If selected, the mapping to the KNIME type you configured is attempted. The node will fail if that is not possible. If unselected, the KNIME type corresponding to the new type is used.","optional":false},{"name":"Transformations","description":"This option allows modifying the structure of the output table. It supports reordering, filtering and renaming columns. It is also possible to change the type of the columns. Whether and where to add unknown columns during execution is specified via the special entry <i>Any unknown column</i> .\n<br />\n<b>Note:</b>\n<br />\nThe transformation matching during execution is based on name. That means if there was a column [A, Integer] during configuration in the dialog and this column becomes [A, String] during execution, then the stored transformation is applied to it. For filtering, ordering and renaming, this is straight forward. For type mapping the following is done: If there is an alternative converter to the specified KNIME type, then this converter is used, otherwise we default to the default KNIME type for the new type. In our example we might have specified that [A, Integer] should be mapped to Long. For the changed column [A, String] there is no converter to Long, so we default back to String and A becomes a String column in the output table.","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:662659c4-120b-43a9-91ca-d8f7f7df852f","user":"ribizli","date":"2020-12-07T14:06:43+00:00"},{"accountId":"account:user:196ce6f6-67ae-4b8c-8e58-4c774c32f2a6","user":"thyme","date":"2021-03-08T19:12:29+00:00"},{"accountId":"account:user:6e639a62-a85d-498c-8112-0f199e557f12","user":"luca_gaona_1","date":"2024-06-05T16:53:28+00:00"},{"accountId":"account:user:10e1d1b6-b702-4512-bada-64a78f4d3e49","user":"david_foucout","date":"2023-05-31T13:11:16+00:00"},{"accountId":"account:user:3a5aea77-6309-4354-8099-fd59b8c12196","user":"paolotamag","date":"2021-02-12T08:56:01+00:00"},{"accountId":"account:user:cffa0c5c-09e4-4eaa-834a-079826e60242","user":"alxpei77","date":"2020-12-09T22:01:08+00:00"},{"accountId":"account:user:89ccdb55-9881-4352-94d7-336a22b52e64","user":"carlwitt","date":"2023-11-20T10:39:04+00:00"},{"accountId":"account:user:415da0b5-f3e1-46d2-ac1a-db17e1b1d7d9","user":"sammyhallgren","date":"2023-04-05T18:24:05+00:00"},{"accountId":"account:user:77e08cd0-6d00-4fb6-bbf5-e6f89a50447c","user":"dennishandt","date":"2020-12-08T11:58:09+00:00"}],"kudosCount":9,"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":[]}