A new Concatenated Table, 'Query1' is created. Notice that the 'Query1' table is in the 'Hierarchical' view since the 'union' symbol is visible on the left of the table, indicating its type, and the table's title row lists all of the tables participating in the union operation.
6. Click the 'Show Editable View' button, located in the upper right corner of the table.
7. Select the 'CUSTOMER_ID' cell and click on the 'Visibility' button to hide it.
8. Double-click the 'COMPANY_NAME' cell, and change the name to 'Company'.
9. Switch back to the 'Hierarchical' view by clicking on the 'Show Hierarchical View' button, located in the upper right corner of the table.
Notice that the column name change does not appear in the hierarchical view. This is because the hierarchical view displays the base table information and the column name has not been changed for the base tables.
10. Preview the table. Notice that the 'CUTOMER_ID' field is hidden and the 'COMPANY_NAME' column header has been renamed to 'Company'.