Forum Discussion
Power Query: Source Files Column Order
Hi, all. I am about to do a Power Query of two excel files that have the same column headers and data types but the order of the columns is slightly different. Does Power Query care if the order of t...
If you mean File->From Folder connector - it shall take column names into account
SergeiBaklan Yes - that is what I mean. So the order of the columns does not matter between the two files as long as they have identical header names and data types.
Yes, and hope nothing changes in recent versions - I didn't check right now. But that's easy to test, few minutes job - create two files with couple of rows each, first have columns A, B, C; second with columns C, B, A. Or like. Query the folder with them, combine and transform, check result, delete files.
SergeiBaklan Many thanks