Predict which orders a filter will drop, nulls included (kite shop)
Before a Qty ≥ 3 filter goes live, list exactly the orders it will remove, including the ones with no quantity.
- Level
- intermediate
- Time
- ~8 min
- Task
- Predict a step's result
- Access
- Free — no account needed
Loading the practice workspace…
About this exercise
What you'll practise
Predict how comparisons with null behave in a row filter.
Northwind Kites sells kites and accessories through three regional stores. Orders are exported from the till system every week.
Steps
- Next week the step
Table.SelectRows(Orders, each [Qty] >= 3)will be added to the report. - Return the orders that step will drop: every row it does not keep. Some orders have a null
Qty. - Keep all columns.
Your result must
- Orders with Qty below 3 are listed
- Orders with a null Qty are listed too
- No order with Qty ≥ 3
Input
- Orders (table)
- OrderID: text
- Customer: text
- Region: text
- Product: text
- Qty: number (nullable)
- UnitPrice: number
- OrderDate: text
- Status: text
Expected output columns
OrderID (text), Customer (text), Region (text), Product (text), Qty (number (some rows null)), UnitPrice (number), OrderDate (text), Status (text)
| OrderID | Customer | Region | Product | Qty | UnitPrice | OrderDate | Status |
|---|---|---|---|---|---|---|---|
| 0001 | Jun Fofana | South | Box Kite | null | 27.35 | 2026-01-05 | Pending |
| 0007 | Sven Grieve | East | Reel | null | 8.46 | 2026-02-13 | Complete |
| 0009 | Hana Mensah | North | Delta Kite | 2 | 39.55 | 2026-05-16 | Pending |