Русские видео

Сейчас в тренде

Иностранные видео


Скачать с ютуб Using a Transformation Table in Power Query's Fuzzy Merges в хорошем качестве

Using a Transformation Table in Power Query's Fuzzy Merges 5 лет назад


Если кнопки скачивания не загрузились НАЖМИТЕ ЗДЕСЬ или обновите страницу
Если возникают проблемы со скачиванием, пожалуйста напишите в поддержку по адресу внизу страницы.
Спасибо за использование сервиса savevideohd.ru



Using a Transformation Table in Power Query's Fuzzy Merges

Excel Summit South: https://excelsummitsouth.com/ Excelapalooza: http://www.excelapalooza.com/ How can we merge data when New York is listed at NYC, New York City and NY, NY? This is a common problem and there's a new feature in Excel's Power Query that can help us solve this. We can build a Transformation Table in Power Query as part of making a join. This video shows how to use a Transformation Table within a Left Outer Join. We go into the new menu for Fuzzy Merges and insert the magical Transformation Table. This is new to Excel and Power Query but Transformation Tables have been part of PowerBI for several months. #TransformationTable #PowerQueryJoins #FuzzyMerge For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course: https://www.linkedin.com/learning/ins... Website: http://ozdusoleil.com My book: Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analy... My old blog: http://datascopic.net/blog-2-2

Comments