This option enables you to rename multiple columns and is similar to the rename multiple tables wizard.
To rename multiple columns:
- Right-click on a model (or group/schema) and choose Attributes>Rename multiple attributes.
REPLACE WITH THIS IMAGE: Images/Attributes/Renaming Multiple Attributes.png
- This can also be done from the Rename multiple entities button in the diagram tool bar. The split button displays the Rename multiple tables and the Rename multiple columns wizard.
REPLACE WITH THIS IMAGE: Images/Attributes/Renaming Multiple Attributes_1.png
- The table name criteria and refine tables list panes of the wizard are identical to the first two panes of the rename multiple tables wizard and allow selecting the tables to be included.
REPLACE WITH THIS IMAGE: Images/Attributes/Renaming Multiple Attributes_2.png
- The Rename columns - Refine tables list dialog enables you to include or exclude tables.
REPLACE WITH THIS IMAGE: Images/Attributes/Renaming Multiple Attributes_refinetable.png
- The Rename columns - Column name criteria dialog enables you to include or exclude column names based on their name in the same way as the 'Entity name criteria' pane.
REPLACE WITH THIS IMAGE: Images/Attributes/Renaming Multiple Attributes_3.png
Icons |
Description |
|---|---|
REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png |
Click to Add a filter. |
REPLACE WITH THIS IMAGE: Images/Common_Icons/renamequeryicon.png |
Click to Edit the selected filter. |
REPLACE WITH THIS IMAGE: Images/Common_Icons/removequeryicon.png |
Click to Delete the selected filter. |
- Click Next to display the Rename columns - Column rename criteria pane.
REPLACE WITH THIS IMAGE: Images/Attributes/Renaming Multiple Attributes_4.png
Icons |
Description |
|---|---|
REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png |
Click to Add a criteria. |
REPLACE WITH THIS IMAGE: Images/Common_Icons/renamequeryicon.png |
Click to Edit the selected criteria. |
REPLACE WITH THIS IMAGE: Images/Common_Icons/removequeryicon.png |
Click to Delete the selected criteria. |
REPLACE WITH THIS IMAGE: Images/Common_Icons/up.png |
Click to move the selected criteria a level Up. |
REPLACE WITH THIS IMAGE: Images/Common_Icons/down.png |
Click to move the selected criteria a level Down. |
- The available criteria is the same as in the rename tables wizard.
REPLACE WITH THIS IMAGE: Images/Attributes/Renaming Multiple Attributes_5.png REPLACE WITH THIS IMAGE: Images/Attributes/Renaming Multiple Attributes_6.png
- After adding some criteria, clicking Derive determines which columns will be renamed and what their new name will be.
REPLACE WITH THIS IMAGE: Images/Attributes/Renaming Multiple Attributes_7.png
- If any name conflicts are found, the next pane enables you to adjust the derived names to resolve them.
REPLACE WITH THIS IMAGE: Images/Attributes/Renaming Multiple Attributes_8.png
- Finally the columns that will be renamed are shown with what they will be renamed to. If you don't want some of these columns to be renamed, deselect the corresponding check-box in the Rename column. Clicking Rename applies the selected renames.
REPLACE WITH THIS IMAGE: Images/Attributes/Renaming Multiple Attributes_9.png