Trim every column except Amount with one generated step (members)
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)
- Member: text
- Club: text
- Amount: number
Expected output columns
Member (text), Club (text), Amount (number)