This lesson's interactive features are locked, please to keep using them

Merging Columns

Sometimes you'll want to combine two columns into one – for example, merging a City column and a State column into a single field like Austin, TX.

Let's create a new column that represents a nicely formatted os/device string, like "windows on desktop".

Assignment

Again, open power query on the website_sessions table.
Hold ctrl and select the columns we want to merge (os and device_type) - the order you select them in matters!
In the Add Column (not "Transform", that would remove the originals) tab click Merge Columns.
- Select "Custom" as the separator and type on (with spaces around it).
- Use os_on_device as the new column's name.
- If you got the names in the wrong order, you can manually change the order in the text representation of the query directly above the table.
Notice that your original os and device_type columns are still there! Merging simply creates a new column, so it's non-destructive.
Close & Apply the query.

Save the project and, from the course directory, submit the CLI tests.