The first table shows 3 columns where the first column is "ship to/customer". If you were to click on the "Invoked Custom Function1" step, you'd see that it adds a new column to the Transaction query. To understand this, we need to look at the steps in the Transaction query: wait… what happened to my customer column? Why is the Customer column missing? I then clicked OK, and was presented with this:Įrr. (I want to rename "ship to/customer", so it's important that it show up here.) The only thing I really want to point out here is that I choose the Example file which has the column name that I do NOT want. Right clicked the query in the Queries pane -> ReferenceĪt this point I was presented with the following window:.Renamed the query to FilesList (making a query that I can use to easily sort/filter the list of files later).Created a new query From File -> From Folder.I dropped these into a folder called "Test" and then In order to replicate this issue, I created two very simple CSV files as shown here: What happens when we try to merge files with different column headers? Plainly there has been a specification change somewhere down the line, but it's causing issues in the combination - an issue that would affect either Excel or Power BI. The issue she's facing is that some of the files in her folder have a column called "customer", where others have a column called "ship to/customer".
![how to have different headers in word 2017 how to have different headers in word 2017](https://www.officetooltips.com/thumbnails/tips/18.png)
![how to have different headers in word 2017 how to have different headers in word 2017](https://recalhelpnow.com/images/507440.jpg)
![how to have different headers in word 2017 how to have different headers in word 2017](https://www.teachucomp.com/wp-content/uploads/header-ms-word-13.png)
How to have different headers in word 2017 how to#
A client contacted me today asking how to merge files with different column headers in Power Query.