Losing Column Values when Using 'Combine' for CSV values

[Anonymous]

Using Combine .csvs for 5 identically formatting CSV files in powerquery. I have a field called 'DATE' which is the first column in the files, and the row values are loading correctly for the first csv file, but for the following 4 files, I'm losing the row values in the column DATE in the other csv's. They are blank, but in the source file csvs they are not.  Any ideas? 

[ImkeF]

Power Quey is case sensitive. So an easy explanation would be that there is a slight deviation in writing. (also spaces and non printable characters could cause problems - Text.Trim and Text.Clean would help.)

Another troublemaker are additional columns, as the automatic expansion that you're using here creates a hardcoded value of columns to expand. Removing that solves that problem.