Power QueryExercises

Append tables whose columns differ in order and set (kite shop)

Web orders have a Discount column, phone orders a Channel column, and their columns are in different orders. Append by name.

Level
intermediate
Time
~8 min
Task
Build the query
Access
Pro
Checking your access…

About this exercise

What you'll practise

Append by column name, not position, and understand the nulls for missing columns.

The scenario, sample data, step list, hints and solution open with Pro. Grading checks your query against hidden data as well as the visible sample, so a query that only fits the sample doesn't pass.

Input

  • WebOrders (table)
    • OrderID: text
    • Customer: text
    • Qty: number
    • Discount: number
  • PhoneOrders (table)
    • Qty: number
    • OrderID: text
    • Channel: text
    • Customer: text

Expected output columns

OrderID (text), Customer (text), Qty (number), Discount (number (some rows null)), Channel (text (some rows null))