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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
novotnajk
Resolver I
Resolver I

Which "Join" to Use for Merging Tables

Hi again!

 

I'm not sure which join feature to use when merging the two tables below.

First, I know that the fields in Table 2 are in Table 1.  Here is a sample:

 

Table 1

Patient ID          Reporting Date          

123456789        1/1/2017

123456789        1/1/2018

 

Table 2

Patient ID          Reporting Date          Risk Score

123456789        1/1/2017                    2.00

123456789        1/1/2018                    3.50

 

I want to merge the Risk Score from Table 2 to Table 1, but apply the risk score based on Patient ID and Reporting Date.

I clicked Merge Queries, selected Table 2, highlighted in Table 1 and Table 2 both fields and selected JoinInner, but I get null records in the larger data set.

 

I'm not sure what I can do.  Like I said, I know that all records that are in Table 2 are in Table 1 based on the two fields.

Thanks for your help!

3 ACCEPTED SOLUTIONS
Nathaniel_C
Super User
Super User

Hi @novotnajk 

Select outer - All from first, matching from second.

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

 

merge tables.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Hi @novotnajk ,

Click on the double arrow, and you will get the following Expand Risk Score. You will the second picture.

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

 

merge tables 1.PNGf

 

merge tables 2.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

@Nathaniel_C  Thank you!  This worked well.  Now I have a relationship problem.  I'll submit a new item!  I hope you can help!

View solution in original post

3 REPLIES 3
Nathaniel_C
Super User
Super User

Hi @novotnajk 

Select outer - All from first, matching from second.

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

 

merge tables.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hi @novotnajk ,

Click on the double arrow, and you will get the following Expand Risk Score. You will the second picture.

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

 

merge tables 1.PNGf

 

merge tables 2.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




@Nathaniel_C  Thank you!  This worked well.  Now I have a relationship problem.  I'll submit a new item!  I hope you can help!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.