Power Query practice: Error Handling & Defensive ETL
Chapter 19 · 5 questions · included in full access
Question 1 · hard
Safe conversion with try
Solve it in your browserSalesRaw's Qty is text and one value is a typo (
3S). Add QtyNum = the number, or 0 when it can't be converted:try Number.From([Qty]) otherwise 0.Question 2 · medium
Remove rows with errors
Solve it in your browserChanging Qty to Whole Number turned the typo
3Sinto an Error. Remove that row: select Qty ▸ Home ▸ Remove Rows ▸ Remove Errors.Question 3 · medium
Replace errors with zero
Solve it in your browserKeep the row this time: Transform ▸ Replace Errors in Qty with
0.Question 4 · medium
Query folding
Solve it in your browserYour source is a SQL Server database. Why filter rows and remove columns early in the recipe?
Question 5 · medium
When to use Table.Buffer
Solve it in your browserWhy would a data engineer wrap a dimension table in
Table.Bufferbefore performing complex nested joins?
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing