Renaming a Column

[hatstand]

Hi All,

After I have Promoted headers. One of the columns is renamed with this example '01/08/2020 TO 07/08/2020'. My problem is that every import the column contains a different range of dates so the line below will not work. I know I can't use wildcards, so getting a bit stuck for solution.

'= Table.RenameColumns(#"Filtered Rows2",{{"01/08/2020 TO 07/08/2020", "Period"}})'

Any pointers would be much appreciated.

 

[sandy666]

1. use xl2bb
2. post representative (structure) source data (use generic values if necessary)
3. post actual M
4. post expected result from your example
5. or post a link to the shared excel file with all above using onedrive, googledrive, dropbox or any similar service

then we will see what we can do

 

[Norie]

If the column is always in the same position you can use Table.ColumnNames to refer to it.

For example if it was the 3rd column you could use this.

'= Table.RenameColumns(#"Filtered Rows2",{{Table.ColumnNames(#"Filtered Rows2"){2}, "Period"}})

Note the columns have a 0-based index, i.e. column 1 index is 0, column 2 index is 1 and so on.

 

[hatstand]

Thanks, that's exactly what I'm after. Very much appreciated.