Power Query #5: Append Tables with Table.Combine Function: Seven Examples
From excelisfun · · 17 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.
If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.
Description
Download Zipped folder with files: https://excelisfun.net/files/PowerQuery05Files.zip Free Power Query YouTube class from Mike excelisfun Girvin: https://www.youtube.com/playlist?list=PLrRPvpgDmw0lHaJfr4mjRcOMEYqKKvKBj Buy Mike Girvin's Power Query M Code book: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832/ Topics: 1. (00:00) Intro Song 2. (00:11) Introduction 3. (00:52) Download files 4. (01:17) Goal for video append external files project 5. (01:53) Six examples that teach the fundamentals of the Append Operation 6. (02:24) Keyboard to open 7. (02:34) Example 1: Append feature in Power Query with the Table.Combine function 8. (03:42) Example 2: Fix Data Types in Source Tables, and Data Types Flow Through to Appended Tables 9. (04:43) Example 3: Append Tables with Inconsistent Field Names 10. (05:40) Example 4 & 5: Ampersand, &, to append tables 11. (07:40) Example 6: Second Argument in Table.Combine Function: Columns. Choose columns to append 12. (07:47) Difference Between “Reference” and “Duplicate” Queries 13. (09:29) Table Type Preview of Video #9 14. (09:53) Table Column M Code Lookup Syntax Preview of Video #9 15. (10:20) Load As “Create Connection Only” 16. (10:31) Edit Load Location to Load Queries to Excel Worksheet 17. (11:03) Fix Source Table Inconsistent Field Names So That Tables Can Append Correctly 18. (12:20) Look at Excel Tables That We Will Import 19. (12:32) Look At the Text Tab Delimited File That We Will Import 20. (12:55) Import Multiple Excel Tables from an Excel File 21. (13:17) Append Two Tables 22. (13:41) Import Text File with a Tab Delimiter 23. (14:06) Append Table to Existing Append Method 1: Edit Source Query Step 24. (14:36) Append Table to Existing Append Method 2: Edit M Code in Formula Bar 25. (15:05) Sort Table By Test Within Student Name 26. (15:15) Table.Sort function 27. (15:27) List Within A List to Sort 28. (16:15) Load To Worksheet 29. (16:49) Summary 30. (17:36) Closing
This video has subtitles or audio translations in these 178 languages: Abkhazian, Afar, Afrikaans, Akan, Albanian, Amharic, Arabic, Armenian, Assamese, Aymara, Azerbaijani, Bambara, Bangla, Bangla (India), Bashkir, Basque, Belarusian, Bhojpuri, Bosnian, Breton, Bulgarian, Burmese, Cantonese, Cantonese (Hong Kong), Catalan, Chinese, Chinese (China), Chinese (Hong Kong), Chinese (Simplified), Chinese (Singapore), Chinese (Taiwan), Chinese (Traditional), Corsican, Croatian, Czech, Danish, Dogri, Dutch, Dutch (Belgium), Dutch (Netherlands), Dzongkha, Esperanto, Estonian, Ewe, Faroese, Fijian, Filipino, Finnish, French, French (Belgium), French (Canada), French (France), French (Switzerland), Fula, Galician, Ganda, Georgian, German, German (Austria), German (Germany), German (Switzerland), Greek, Guarani, Gujarati, Haitian Creole, Hausa, Hawaiian, Hebrew, Hindi, Hungarian, Icelandic, Igbo, Indonesian, Inuktitut, Irish, Italian, Japanese, Javanese, Kalaallisut, Kannada, Kazakh, Khmer, Kinyarwanda, Konkani, Korean, Kurdish, Kyrgyz, Lao, Latin, Latvian, Lingala, Lithuanian, Luo, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malay (Singapore), Malayalam, Maltese, Marathi, Mizo, Mongolian, Mongolian (Mongolian), Māori, Nepali, Northern Sotho, Norwegian, Occitan, Odia, Oromo, Papiamento, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Portuguese (Portugal), Punjabi, Quechua, Romanian, Rundi, Russian, Samoan, Sango, Sanskrit, Santali, Scottish Gaelic, Serbian, Serbian (Cyrillic), Serbian (Latin), Shona, Sicilian, Sindhi, Sinhala, Slovak, Slovenian, Somali, South Ndebele, Southern Sotho, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Sundanese, Swahili, Swati, Swedish, Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Tigrinya, Tok Pisin, Tongan, Tsonga, Tswana, Turkish, Turkmen, Ukrainian, Urdu, Uyghur, Uzbek, Venda, Vietnamese, Welsh, Western Frisian, Wolof, Xhosa, Yiddish, Yoruba, Zulu. Click gear…