What is that customer’s name? Well, there are actually 3 of them. Maybe some of them are informal variations on a longer name (“Robert” becomes “Bob”), others might be from typos when the data was entered. Either way, you have to take a list of conflicting names for a customer and squeeze them into a single cell so you can see/search-for each and every version within your data. In this video Brian Grant will walk you through how you can leverage some more advanced features of the Power Query M language to achieve exactly that. He’ll show you both a longer method to help you understand the concepts and a shorter/faster method for when you want to get to the results you need quickly.
The SkyPoint AI Platform
Our AI Platform for industries helps unify your data, chat with your data, and optimize productivity.
Drive enterprise AI and digital transformation with our Professional Services.
Data and AI Solutions
SkyPoint AI delivers an industry-specific platform infrastructure enabling quick access to quality data, intelligence, analytics, and automation.
Data and AI Resources
Trainings, strategies, techniques, and experiences from our data solutions experts and customers.
Training and Events
Get in Touch
We bring people and data together by making information more accessible, reliable, valuable, and tangible.