Skip the title rows in a report export (consultancy)
The export starts with a report title and a blank line. Skip them, then promote the real headers.
- Level
- beginner
- Time
- ~7 min
- Task
- Build the query
- Access
- Free — no account needed
Loading the practice workspace…
About this exercise
What you'll practise
Remove top rows before promoting headers, and understand why the order of those steps matters.
Brightline Advisory (fictional) reimburses consultants' expenses. Finance exports claims monthly from the expense tool.
Steps
- The first two lines are a report title and a blank line. Remove them.
- Use the next row as headers.
- Set
Amountto a decimal number (en-US). Leave the other columns as text.
Your result must
- Columns: ClaimID, Employee, Category, Amount, Currency, ClaimDate, Approved
- No title or blank rows in the data
- Amount is a number
Input
- ClaimsReport (file)
- Text file; first line: Expense claims report,,,,,,
- Every field is text until you set types
Expected output columns
ClaimID (text), Employee (text), Category (text), Amount (number), Currency (text), ClaimDate (text), Approved (text)
| ClaimID | Employee | Category | Amount | Currency | ClaimDate | Approved |
|---|---|---|---|---|---|---|
| C-0001 | Goran Brandt | Training | 291.59 | USD | 2026-05-05 | Yes |
| C-0002 | Dmitri Yilmaz | Software | 141.6 | USD | 2026-03-12 | No |
| C-0003 | Goran Brandt | Meals | 364.66 | USD | 2026-05-09 | No |