{"title":"RowID","nodeType":"Manipulator","id":"*1Uo48m8MIHW-seLx","factoryName":"org.knime.base.node.preproc.rowkey2.RowKeyNodeFactory2","factoryId":"org.knime.base.node.preproc.rowkey2.RowKeyNodeFactory2","path":["Manipulation","Row","Other"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node can be used to extract the values of the current RowID of an input table to a new column. The node can also be used to replace the current RowID of the input table with a generated RowID of the format: Row0, Row1, Row2, ..., or by the values of a selected column (by converting the values to string). In the latter case, the node provides options to ensure uniqueness and to handle missing values in the selected column. If both extraction of the RowID and replacement of the RowID are configured, the node appends a new column with the values of the current RowID to the table and replaces the current RowID with the values of the selected column or the generated RowID. Note: Hiliting does not work across this node if the &#34;Enable hiliting&#34; option is disabled.</p>\n        ","shortDescription":"Node to extract the RowID to a column and/or to replace the RowID.","keywords":[],"deprecated":false,"streamable":true,"tags":["Manipulation","Row","Other","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6OEY2NDNEREE4OUY2MTFFNTkyQzJBQjlCNTFCMUUyMzIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6REEzQzk4Njg4OUVBMTFFNTkyQzJBQjlCNTFCMUUyMzIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDozRkIzMDU3MjE2OEMxMUU1QkQ5NUExQjU5MUVDNkZCQiIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDozRkIzMDU3MzE2OEMxMUU1QkQ5NUExQjU5MUVDNkZCQiIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PisOx0EAAABWSURBVHjaYvz//z8DJYCRUgNYQETPtNXkmsLIAtKcnBRElu6589b9Z2KgELAQYQuGGLKLCRpAyHujLmBgoDgaKTaAsXvqKhBNVlIGeo+RccBzI0CAAQCheyXeo1W0AQAAAABJRU5ErkJggg==","sinceVersion":"2.6.0","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input Table","description":"The data table whose RowID to extract and/or replace."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Output Table","description":"The input table with a new column of extracted RowID values and/or with its RowID replaced."}],"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":"Replace RowIDs","description":"If selected the RowIDs will be replaced","optional":false},{"name":"Replacement mode","description":"Replace the RowID by a newly generated one or the values of a column.\n<ul><li><b>Generate new</b> : If selected, a new RowID is generated with the format: Row0, Row1, Row2, ...</li><li><b>Use column</b> : If selected, the RowID is replaced by the selected column.</li></ul>","optional":false},{"name":"ID column","description":"The column to replace the current RowID.","optional":false},{"name":"Remove selected ID column","description":"If selected, the column replacing the current RowID is removed from the table.","optional":false},{"name":"If ID column contains missing values","description":"Fail if encountering missing values, or replace them.\n<ul><li><b>Fail</b> : If selected, the node fails if a missing value is encountered in the selected column.</li><li><b>Replace by &#34;?&#34;</b> : If selected, missing values are replaced with &#34;?&#34;. We recommend also enabling the&#34;Append counter&#34; option to handle any duplicate missing values.</li></ul>","optional":false},{"name":"If ID column contains duplicates","description":"Fail if encountering duplicate values, or make them unique.\n<ul><li><b>Fail</b> : If selected, the node fails if a duplicate value is encountered in the selected column.</li><li><b>Append counter</b> : If selected, uniqueness is ensured by appending an incrementing number to duplicates.</li></ul>","optional":false},{"name":"Enable hiliting","description":"If selected, a map is maintained joining the old with the new RowID. Depending on the number of rows, enabling this feature might consume a lot of memory.","optional":false},{"name":"Append column with RowID values","description":"If selected, a new column with the values of the current RowID is appended to the table.","optional":false},{"name":"Column name","description":"The name of the column to append to the 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":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.14450103754008678},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.07979626485568761},{"id":"*rqhXsa-dMez9coq4","factoryName":"org.knime.base.node.preproc.transpose.TransposeTableNodeFactory","probability":0.06564799094510469},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.03621958121109225},{"id":"*eOn8ibZnxIkY7XhT","factoryName":"org.knime.base.node.preproc.stringmanipulation.StringManipulationNodeFactory","probability":0.035653650254668934},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.025844180343331448},{"id":"*PHWv6FsABEjrSc76","factoryName":"org.knime.base.node.preproc.rename.RenameNodeFactory","probability":0.023580456517638182},{"id":"*0rhLXWO6OS1xMi8T","factoryName":"org.knime.base.node.preproc.append.row.AppendedRowsNodeFactory","probability":0.02282588190907376},{"id":"*_zMUh-EpYjdvFKW9","factoryName":"org.knime.base.node.preproc.columnappend.ColumnAppenderNodeFactory","probability":0.020184870779098283},{"id":"*gwwIZ5c5EYsJErci","factoryName":"org.knime.base.node.preproc.sorter.SorterNodeFactory","probability":0.015091492171288436}]}