Forum Discussion

slohombre's avatar
slohombre
Brass Contributor
May 23, 2020

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...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 23, 2020

slohombre 

If you mean File->From Folder connector - it shall take column names into account

  • slohombre's avatar
    slohombre
    Brass Contributor
    May 23, 2020

    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.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      May 23, 2020

      slohombre 

      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.

Resources