Forum Discussion
Combine 2 files with different format
Hi Yasser92,
Yes you can combine these files. I think you will be using Append/ Merge Queries for the same as per your need.
One take is, when you combine these data sets, you can remove the unwanted columns and combine the data sets. In case if there is a file that has an additional column, that column also will get appended while all the records who don't have that information will be null
Hi Yasser92,
Yes you can combine these files. I think you will be using Append/ Merge Queries for the same as per your need.
One take is, when you combine these data sets, you can remove the unwanted columns and combine the data sets. In case if there is a file that has an additional column, that column also will get appended while all the records who don't have that information will be null
Thank You lot Thejeswar,
Do you think that Append Merge will be useful in my case even if I have more than 20 excel's data sheets
Hi,
Suppose you have 20 different files in your DB and you want them to make 1 data set, then the only option is UNION or UNION ALL
Similarly, as far as I know, appending the data sets in Power BI is the way to go as it is the equivalent of SQL Union in Power BI