Dynamic Table Header Changes

[happyhungarian]

Hi, I've been searching for a solution to this and have found several all-most solutions. I was hoping to dynamically update the header columns of a table (let's call this table the Info_Table) in power query using a table I have in the workbook that I have created a connection for (called Date_Table). I've been trying to use the list of list solution converting the Date_Table to a list of list and then Table.RenameColumns function in the Info_Table but I want it to only change the headers for which it finds a match in the Date_Table. The reason for this is the column headers on a few columns in the Info_Table could change month to month but most of the columns stay exactly the same. And it's only the columns that stay the same that I can continually reference that I want Power Query to change. Is this possible?

Thanks!
J

 

[RoryA]

It would help to see what you're using at the moment as a query, but can't you just remove the columns that might change from the mapping table? Or don't you know what they are in advance?