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))