cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yasser92 Frequent Visitor
Frequent Visitor

Combine 2 files with different format

Hi!

 

I am looking for a solution to below problem and would highly appreciate

the solution to this.

Is it possible to combine two excel's files with different format. 

 

For example : 

File 1 : 

 

 ABC
1Order NLine NDelivery Date
2L12115/01/2017
3L12717/02/2017
4L13102/03/2017
5L14220/03/2017
6L15419/05/2017
7L15501/02/2017
8L14301/02/2017
9L20108/08/2017

 

 

File 2 

 

 ABCD
1Order NLine NDeadline Delivery Date
2L12120/08/201721/08/2017
3L12715/08/201722/08/2017
4L13122/08/201723/08/2017
5L14321/08/201724/08/2017
6L11223/08/201725/08/2017
7L154  
8L15519/08/201724/08/2017
9L14519/08/201724/08/2017
10L12  
11L21230/07/201701/08/2017
12L301  
13L12123/08/201724/08/2017

 

 

And after combinining, have a table result : 

 

Order NLine NDelivery Date
L12115/01/2017
L12717/02/2017
L13102/03/2017
L14220/03/2017
L15419/05/2017
L15501/02/2017
L14301/02/2017
L20108/08/2017
L12121/08/2017
L12722/08/2017
L13123/08/2017
L14324/08/2017
L11225/08/2017
L154 
L15524/08/2017
L14524/08/2017
L12 
L21201/08/2017
L301 
L12124/08/2017

 

 

I have more than 20 files with two or tree format.

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Thejeswar Senior Member
Senior Member

Re: 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

View solution in original post

5 REPLIES 5
Super User
Super User

Re: Combine 2 files with different format

Are you using the Combine Binaries (folder query)?


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Thejeswar Senior Member
Senior Member

Re: 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

View solution in original post

Yasser92 Frequent Visitor
Frequent Visitor

Re: Combine 2 files with different format

Thank you for the response.

 

Yes, I'm using a file as a source

Yasser92 Frequent Visitor
Frequent Visitor

Re: Combine 2 files with different format

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

Thejeswar Senior Member
Senior Member

Re: Combine 2 files with different format

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 318 members 3,202 guests
Please welcome our newest community members: