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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

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

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors