This operation reorders, renames and deletes columns.
Example: Change the name of the column "Data" to "Value".
Situation | ![](_scroll_external/attachments/86f6b4d18f20/reorder_rename_columns_table.png)
|
Operation settings | - You get into the editing mode by clicking the icon
![Bearbeiten](_scroll_external/remote/85012b77db04/bearbeitenicon.png) - You need to confirm changes by clicking the icon
![Übernehmen](_scroll_external/remote/60b2ed6c28df/okicon.png) - Delete columns with the icon
![Löschen](_scroll_external/remote/464f3ca39ae3/delete1icon.png) - You can change the order of columns (how they will be displayed in the result table) with the icons
und ![Nach oben](_scroll_external/remote/1eb06ac030c9/moveupicon.png)
![](_scroll_external/attachments/ef6f22dbcc21/reorder_rename_columns_rename.png)
Please note: You can recover accidentally deleted rows by clicking on the icon "new row" on the bottom right. |
Result | ![](_scroll_external/attachments/63a23a3dec39/reorder_rename_columns_result.png)
|
TIS Project | none |
Settings
This operator renames and reorders columns.
Troubleshooting
Problem | Frequent Cause | Solutions |
---|
General error messages | Error messages are often due to columns having been renamed in a preceding node and the current renaming process lacking reference. | Have a look at the individual columns and check whether the variable is available in the left column - if necessary delete rows or select correct column name. |
"An Item with the same key has already been added" | This can happen if two columns have the same name, typically after data merging. | Workaround: delete one of the two columns with the operation Delete columns and then proceed with renaming / reordering / deleting columns. |
Delete columns
Split Columns