Updates column names of a table according to the mapping in second dictionary table. The dictionary table needs to contain two columns, one of which contains the lookup (i.e. the column names of the table to be renamed), the other column containing the new column names. The lookup column may be the RowID column.
\n \nIf the assigned new value in the value column is missing, the original column name will be retained. If the lookup column contains duplicates of the original column names, the node will fail.
\n \n \n ","shortDescription":"Updates column names of a table according to the mapping in a second dictionary table.","keywords":["Rename column"],"deprecated":false,"streamable":true,"tags":["Manipulation","Row","Other","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3hpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6M0ZCMzA1NkYxNjhDMTFFNUJEOTVBMUI1OTFFQzZGQkIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6M0ZCMzA1NkUxNjhDMTFFNUJEOTVBMUI1OTFFQzZGQkIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDplYjRlYWE5NS1mMzM5LTQzZTctYmY1Yy0yNzFmOThkY2ZiMmIiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6MGIzNmFjOTctNWViYS00MGU3LTkxODktYmJlOGQ3ZDBmMjRlIi8+IDwvcmRmOkRlc2NyaXB0aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+gje0RgAAAKBJREFUeNrEUosKgzAMzNX4BaPa6f7/zzbYTzQz00mMDnyBB21pmruQXNHUrZDD6/2keKuo5HISS/FOIYRpsgp4dOFVMeUGOojrBVi3Nj1mD3VMxAX7eRGAmQBOa0Gtyjl/K/nqNud36tIsWVEIKmrJAwSDx31W15+5kpkPLMm0vfkfyKILO8iyRwCGODrH/g8sef1HpA/4oW3FYYGPAAMAonZqLedn9R0AAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Data table","description":"Table whose columns are to be renamed."},{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Dictionary table","description":"Table containing two columns: lookup and new value."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Data Table with new column names","description":"Input table, whereby the columns are renamed according to the dictionary."}],"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":"Lookup column","description":"The column in the 2nd input table containing the "old" names of the columns.","optional":false},{"name":"Names column","description":"The column in the 2nd input table containing the "new" names of the columns.","optional":false},{"name":"Fail if no assignment in dictionary table","description":"If selected, the node fails if there is no matching entry of a column name in the dictionary table. Otherwise it will keep the original column name.","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:f8f63396-fafc-4fcf-9578-868216d5fe68","user":"wikusuma","date":"2024-01-19T10:28:51+00:00"},{"accountId":"account:user:18ced5b3-f9bd-4748-9cd3-da299958c097","user":"zassou_syk","date":"2024-12-08T06:29:20+00:00"},{"accountId":"account:user:552210dd-3dfc-4b47-bbe6-477d972e6b9e","user":"nilotpalc","date":"2022-04-14T07:15:14+00:00"}],"kudosCount":3,"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":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.07547169811320754},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.0660377358490566},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.057951482479784364},{"id":"*_zMUh-EpYjdvFKW9","factoryName":"org.knime.base.node.preproc.columnappend.ColumnAppenderNodeFactory","probability":0.03234501347708895},{"id":"*AApA5VHd41CVDe7u","factoryName":"org.knime.base.node.meta.looper.LoopEndNodeFactory","probability":0.03099730458221024},{"id":"*LBLxD9VX3jSsQcU1","factoryName":"org.knime.base.node.preproc.filter.columnref.ColumnFilterRefNodeFactory","probability":0.029649595687331536},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.029649595687331536},{"id":"*0rhLXWO6OS1xMi8T","factoryName":"org.knime.base.node.preproc.append.row.AppendedRowsNodeFactory","probability":0.02830188679245283},{"id":"*CCMhDNWHYFXV506q","factoryName":"org.knime.base.node.meta.looper.LoopEndJoin2NodeFactory","probability":0.02830188679245283},{"id":"*1Uo48m8MIHW-seLx","factoryName":"org.knime.base.node.preproc.rowkey2.RowKeyNodeFactory2","probability":0.025606469002695417}]}