Power Query Combine Files with Different Column Names - Super EASY! - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 7
texian2112
Great video love all of your videos. Can I ask what your approach would be if you were given a file with 3000 columns with merged columns so entries for about 1500 items in 2 columns and you need to add up the information in each of these 2 columns to get the values for 100 rows of data? The first column of the pair has a name and the second is column1 through column1500. My first instinct is to run away screaming but there must be some way to transform this into usable data -
reply
Great video love all of your videos. Can I ask what your approach would be if you were given a file with 3000 columns with merged columns so entries for about 1500 items in 2 columns and you need to add up the information in each of these 2 columns to get the values for 100 rows of data? The first column of the pair has a name and the second is column1 through column1500. My first instinct is to run away screaming but there must be some way to transform this into usable data -
reply
Jean-S-bastien
How do you deal with the different date formats? One of the file uses day/month/year (wich is the good way) and the other file uses month/day/year (wich shouldn't NEVER be allowed!) When you change the data type to dates, the M/D/Y change properly the other ones give errors. These are small things that make computing even more difficult for no reason. I also have to deal with comas and points since I'm using a French Excel.
reply
How do you deal with the different date formats? One of the file uses day/month/year (wich is the good way) and the other file uses month/day/year (wich shouldn't NEVER be allowed!) When you change the data type to dates, the M/D/Y change properly the other ones give errors. These are small things that make computing even more difficult for no reason. I also have to deal with comas and points since I'm using a French Excel.
reply
Chris
Thank you for this and ALL your videos (especially PQ). I used this technique recently to compare data extracted from a source system and Power BI. I was able to complete my analysis in minutes vs. hours AND it's easily repeatable. Thank you again for all your great work! I recommend your videos to all my colleagues an anyone else looking to level up their skills!
reply
Thank you for this and ALL your videos (especially PQ). I used this technique recently to compare data extracted from a source system and Power BI. I was able to complete my analysis in minutes vs. hours AND it's easily repeatable. Thank you again for all your great work! I recommend your videos to all my colleagues an anyone else looking to level up their skills!
reply
Harry
Good day and video! Question about the video around the 6:57 mark. The instruction removes duplicated item and date fields. Does this procedure remove data from the value field from original set of tables? It appears that value data would be lost. Thanks for the work on these!
reply
Good day and video! Question about the video around the 6:57 mark. The instruction removes duplicated item and date fields. Does this procedure remove data from the value field from original set of tables? It appears that value data would be lost. Thanks for the work on these!
reply
suman
Hi mynda
I have data set consist column city, mon, tue ..... Etc, total sales, commission, bonus, rank
And I have assign rank to each city
As per column ( sales rank
609 2)
By using range lookup formula
I can't understand how to use to do this
reply
Hi mynda
I have data set consist column city, mon, tue ..... Etc, total sales, commission, bonus, rank
And I have assign rank to each city
As per column ( sales rank
609 2)
By using range lookup formula
I can't understand how to use to do this
reply
Wayne
Awesome Mynda and Phil! Thanks for demonstrating the various techniques and transformations, as well as for providing the sample files to follow along. Very helpful! Thumbs up!!
reply
Awesome Mynda and Phil! Thanks for demonstrating the various techniques and transformations, as well as for providing the sample files to follow along. Very helpful! Thumbs up!!
reply
boniek90wdn
Question: isn't it faster to modify transform sample table? By faster I mean both coding it as a user and faster for PB/PQ to transform file. Can you advise?
reply
Question: isn't it faster to modify transform sample table? By faster I mean both coding it as a user and faster for PB/PQ to transform file. Can you advise?
reply
Add a review, comment
Other channel videos
