Combining files with different column names in Power Query can be tricky. In this video we look at two scenarios and several ways to tackle it. Download the Power BI Desktop file here:
www.myonlinetraininghub.com/c...
Learn Power Query with Mynda here: www.myonlinetraininghub.com/e...
Connect with Mynda on LinkedIn: / myndatreacy
0:00 Introduction
0:30 Example 1 CSV file data
1:48 Get files from a folder
2:49 The problem
3:15 Perform transformation on Tables in a column
7:39 Example 2 CSV file data
9:03 The problem
9:31 Solution 1
11:42 Solution 2
12:30 Solution 3
13:07 Solution 4
Негізгі бет Ғылым және технология Power Query Combine Files with Different Column Names - Super EASY!
Пікірлер: 115