Which "Join" to Use for Merging Tables

[novotnajk]

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!

[Nathaniel_C · Accepted 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

[Nathaniel_C · Accepted solution]

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

[Nathaniel_C · Accepted 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

[Nathaniel_C · Accepted solution]

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

[novotnajk · Accepted solution]

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