datadad.blog

Hi there, welcome to my blog

As you can guess, I do data and I’m a proud dad, so the blog name is not a mystery 🙂 This is my project, with topics about data analytics, data visualization and business intelligence. Enjoy.

What are translation tables in Power Query’s Fuzzy Match and why would we need them?

In Power Query, we have the option to use Fuzzy Match when merging tables. A little known feature are the Translation Tables which help in that process. Merging tables is relatively straightforward in Power Query – choose the left table, choose the right table, mark the columns for the merge to be made onto, choose … Continue reading What are translation tables in Power Query’s Fuzzy Match and why would we need them?


Follow My Blog

Get new content delivered directly to your inbox.