Power Query practice: Text Splitting, Extraction & Delimiters
Chapter 6 · 5 questions · included in full access
Question 1 · medium
Split Region and Rep
Solve it in your browserRegionRep holds values like
North|Asha Verma. Split it by the delimiter|into two columns, then rename them Region and Rep.Question 2 · medium
Email domain
Solve it in your browserTurn Email into just its domain in lower case (
Rahul.Sharma@GMAIL.com→gmail.com): Extract ▸ Text After Delimiter@, then Format ▸ lowercase.Question 3 · easy
City from location
Solve it in your browserKeep only the city in Location (
Jaipur, RJ→Jaipur) using Transform ▸ Extract ▸ Text Before Delimiter with,.Question 4 · medium
Merge two columns
Solve it in your browserCombine Region and Rep into one column named Owner, separated by
-(space, dash, space). Select Region then Rep, then Transform ▸ Merge Columns.Question 5 · medium
Why merges fail silently
Solve it in your browserYou merge Orders with Products on Product, but "ACP Sheet Silver " finds no match. Most likely cause?
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing