See how to import three tables from three different source files (Access database, Excel File, Text File) and merge them into one table using Power Query. Merge tables into the PowerPivot Data Model or an Excel Table
1. (01:38 minute mark) Import Access File. Remove column, Format Data Type as Date
2. (02:33 minute mark) Import Excel File
3. (03:05 minute mark) Import Text File
4. (03:28 minute mark) Append Table: merge Three Tables
5. (04:12 minute mark) Load to Data Model or Excel Table
1. (01:38 minute mark) Import Access File. Remove column, Format Data Type as Date
2. (02:33 minute mark) Import Excel File
3. (03:05 minute mark) Import Text File
4. (03:28 minute mark) Append Table: merge Three Tables
5. (04:12 minute mark) Load to Data Model or Excel Table
No comments:
Post a Comment