Combine files that each start with banner lines (kites)
Every export starts with two banner lines before the header. Write one transform for a file and apply it to all of them.
- Level
- advanced
- Time
- ~12 min
- Task
- Build the query
- Access
- Pro
Checking your access…
About this exercise
What you'll practise
Turn a sample-file transformation into a function and apply it to every file in a folder.
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
- OrdersFolder (folder)
- Columns: Content (binary), Name, Extension, Date modified, Folder Path
- File orders-2026-01.csv
- File orders-2026-02.csv
Expected output columns
Source.Name (text), OrderID (text), Customer (text), Qty (number)