Power QueryExercises

Choose columns when one of them is optional (kite shop)

Some exports include a Notes column and some don't. Keep the same four columns either way.

Level
intermediate
Time
~7 min
Task
Build the query
Access
Free — no account needed
Loading the practice workspace…

About this exercise

What you'll practise

Use Choose Columns with a missing-field option so an optional column can't break refresh.

Northwind Kites sells kites and accessories through three regional stores. Orders are exported from the till system every week.

Steps

  1. Keep OrderID, Customer, Qty and Notes.
  2. Some weeks the export has no Notes column. Then the query must still run and return a Notes column filled with null.

Your result must

  • Columns: OrderID, Customer, Qty, Notes
  • Works when Notes is missing
  • Notes is null when the export didn't include it

Input

  • Orders (table)
    • OrderID: text
    • Customer: text
    • Region: text
    • Product: text
    • Qty: number
    • UnitPrice: number
    • OrderDate: text
    • Status: text
    • Notes: text

Expected output columns

OrderID (text), Customer (text), Qty (number), Notes (text)

First 3 of 12 expected rows
OrderIDCustomerQtyNotes
0001Esi Brandt5
0002Tariq Rahman6Gift wrap
0003Rosa Eklund8Leave at door