Duplicating a column

Another common transformation step under the Add Column tab is duplicating a column. In many scenarios, we may wish to duplicate a column, such as when we want to keep the original column available in our model while we need to transform it into a new column. Let's revisit the scenario that we looked at earlier in this chapter in the Split column by delimiter section. In that scenario, we split the OrderDateTime column from the Internet Sales table into two columns, Order Date and Order Time. In this section, we will do this another way. We will work on a duplicate table we created from Internet Sales before splitting the OrderDateTime column for this scenario. We will name the new table Internet Sales Duplicate.

Note

Duplicating a query will be explained in more detail in the Duplicating and referencing queries section of this chapter.

The following steps show how to achieve this:

1. Select the Internet Sales Duplicate table from the Queries...