Merging, copying, and appending queries

Now that we have cleaned up our data, we still require some additional data and transformations to occur to prepare our data for analysis. Specifically, we need to add our additional month data around hours billed to customers, as well as some additional transformations.

In the following sections, we will be performing more advanced transformations of our data, including merging queries, expanding tables, and appending queries.

Merging queries

Note that in the January query, there is a column called TaskID. The values in this column match the values in the TaskID column from our Tasks query. This Tasks query has additional information about each of these tasks regarding whether or not the task is Billable, or some other category, such as PTO, Int Admin, Sales Support, and Training. It would be good to have this information included in our January table. To accomplish this, we will merge the two queries by performing the following steps...