Do you need to bring data from multiple files into one table because the column structures, data types, etc. are similar? Learn how to quickly do this in the video below.
In this video, I showcase how to bring in two different data sources that contain similar data and append/combine them into one table. This is useful to the user so you don’t have to go to the original data source and duplicate data to get what you need all in one table. Also, addressed is the scenario of what if I have different names for my columns or extra columns in one dataset compared to the other.
I use some play educational data, but hopefully, you will see how to apply this to your business scenario. 👍
If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Matt20" at check out when purchasing our On-Demand Learning classes to get an extra 20% off - https://pragmaticworks.com/pricing/