How can I maintain a workflow with tables and columns that their names change?

[Anonymous]

Hello

I load a file from the web that contains a table named Table_21/01/2020 and it has some columns named like ColumnA_21/01/2020.

These names will change every month, so they will become Table_24/02/2020 and ColumnA_24/02/2020 etc.

How can I maintain a processing workflow regardless of the changes in the names of the table and columns?

Thanks!

[parry2k]

@Anonymous assuming all the column have same position, don't use promot header step in your power query, rather remove first row and give column name by renaming it. That will work.

[Anonymous]

Thanks!

But how can I handle the changes in the names of the sheets/tables?

Thanks