Скачать или смотреть The ULTIMATE Append Hacks in Power Query | Power BI

In this video, I show you can append tables together, either by appending just 2 tables or multiple files from a folder and also how to capture all columns of data, even if new columns show in new files saved in the folder you are picking up the data from.

#powerbi #powerquery #append


📁 Dataset -
https://data.world/deanchereden/super...


🔖c h a p t e r s 🔖

00:00 - Intro
00:24 - Simply append 2 files
04:36 - Append multiple files from a folder
07:57 - Auto add new columns from new files
08:53 - Step 1 - Turn tables into a list
09:52 - Step 2 - Create a list of all columns
11:03 - Step 3 - Append all column names
11:38 - Step 4 - Remove duplicate column names
12:14 - Step 5 - Append all data to columns


💌 My email - [email protected]
🌍 My website - https://www.deanchereden.com
🐦 Twitter -   / deanchereden  

🎵 Vhsceral - Gimetime https://chll.to/dd82e17f

🎶 Listen to Chillhop Music -    • Misha & Jussi Halme - Bliss (A Felicidade)...