Trim every column except Amount with one generated step (suppliers)
Text columns are padded with spaces, and new ones keep appearing. Build the Table.TransformColumns list from the column names.
- Level
- advanced
- Time
- ~10 min
- Task
- Build the query
- Access
- Pro
Checking your access…
About this exercise
What you'll practise
Pass functions as values: generate a list of {column, function} pairs at refresh time.
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
- Export (table)
- Supplier: text
- Town: text
- Amount: number
Expected output columns
Supplier (text), Town (text), Amount (number)