cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

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.

1 REPLY 1
Highlighted
Community Support
Community Support

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

Hi @dehmos27 

Do you have tables as below?

Capture1.JPG

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.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors