Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |