Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Harvey85
Helper I
Helper I

Merge Columns

Hello,

I have the following table in Power Query:

Key Plant_MaterialPlant_Area Seed_Date Seed_Total
AA1123 PP STAFF 115 30/11/2023 149
AA1123 PP STRINGS 2134 30/11/2023 149

 

The issue is that I'm building a report where I'm adding to that table (with Merge button), the following columns by Key:

Key Replant_Material Replant_Area Replant_Date
AA1123 XR MAPS 3 11 23/01/2024
AA1123 QP SPLT 2 93 23/01/2024

 

But the problem is that I end up with the followin table with 4 rows instead of 2:

Key Plant_Material Plant_Area Seed_Date Plant_Area_Total Replant_Area Replant_Date Replant_Material
AA1123 PP STAFF 1 15 30/11/2023 149 11 23/01/2024 XR MAPS 3
AA1123 PP STRINGS 2 134 30/11/2023 149 11 23/01/2024 XR MAPS 3
AA1123 PP STAFF 1 15 30/11/2023 149 93 23/01/2024 QP SPLT 2
AA1123 PP STRINGS 2 134 30/11/2023 149 93 23/01/2024 QP SPLT 2

 

And I should keep the 2 rows with something like this:

Key Plant_Material Plant_Area Seed_Date Plant_Area_Total Replant_Area Replant_Date Replant_Material
AA1123 PP STAFF 1 15 30/11/2023 149 11 23/01/2024 XR MAPS 3
AA1123 PP STRINGS 2 134 30/11/2023 149 93 23/01/2024 QP SPLT 2

 

I believe there is not a minimal key to join both tables by Key+Material because I'm building that table as a flat table with all columns, but is there any way to add those column so that my original table don't add more rows?

 

Thank you!!!

1 ACCEPTED SOLUTION
HotChilli
Super User
Super User

You could add an index column to both tables and Merge on that. The order of both tables will have to be correct before adding the index.

View solution in original post

1 REPLY 1
HotChilli
Super User
Super User

You could add an index column to both tables and Merge on that. The order of both tables will have to be correct before adding the index.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.