Data Transformation Basics in Power Query Editor – Part 4

Text Tools Workaround

In the customer table:
1. Make the Prefix, FirstName and LastName column uniform making them capitalize each word setting from Transform Tab—Text Tools
2. From Add Column-- Text Tools options merge the Prefix, FirstName and LastName column, name the output column as Full Name
Text Tools Activity

In the customer table:
1. Duplicate email address column – name it Doman name
2. The new column you only keep the domain name and remove all other text ( column should only contain domain name and not .com or any other)
3. Apply formatting tools in domain name to clean them and Capitalize the domain name column values
4. Save and Apply changes

Видео Data Transformation Basics in Power Query Editor – Part 4 канала Preeti Mishra