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.
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!
Solved! Go to Solution.
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
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
f
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!
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
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
f
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!
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |