Is it possible to merge table columns before expanding table columns in a Folder import?

[dehmos27]

I have a scenario where I am combining multiple tables in a workbook, but each table has a few columns that are inconsistently titled. I need to combine them all into a single table, but I cannot do so effectively as the inconsistent column titles result in separate columns (e.g., Warranty and Warr appear as two separate columns). I am wondering if it possible for me to create a separate table that lists a column name/correct column pairing (as shown below) and have Power BI merge the source data columns based on this before expanding the data in those columns:

Column        Correct Column

Warr                 Warranty

For example, when the tables in the SourceData table are expanded, PBI first checks to see if Warr exists in the table. If it does, then it changes the column name to Warranty so the appended data displays correctly.

[v-juanli-msft]

Hi @dehmos27 

Do you have tables as below?

You want to merge two tables to get the following table, right?

id	correct column	inter
1	warranty	sd
2	werranty	d

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.