Join data from a filtered data set and all data

[LoganD601]

Hi, I am a beginner in Alteryx and am attempting to join data from two excel sheets. Both sheets have a same common ID field so I am able to use a join to get them to join the data. However, I do not want to see all of the ID's. I only want to add data from the large data set to the already filtered data, if that makes sense. Here is an example of what I want to do:

Here's the filtered data (Excel sheet 1):

Student ID	Grade
123	3.56
213	3.7
251	3.52
521	4.11
621	3.85
653	3.55

Here's the data set (Excel sheet 2):

Student ID	Semester Grade	Overall GPA	Status
123	3.56	3.42	FR
124	4.22	3.88	JR
125	2.88	3.12	SR
126	3.31	3.04	FR
127	3.22	4.01	FR
128	4.01	3.85	SP
129	3.96	4.02	JR
130	2.78	3.45	JR
131	2.97	3.22	SR
etc, all the way to student 1000

So, I would like the output of joining the two tables to be something like this 

Student ID	Grade	Status
123	3.56	FR
213	3.7	FR
251	3.52	FR
521	4.11	SR
621	3.85	JR
653	3.55	JR

What it's doing now, is it will just add both data sets to eachother, instead of merging them, and I'm not sure how to only have it output rows where the Student ID's match. This is probably really simple, but I started with Alteryx a couple of weeks ago and am still learning. Thanks!

[christine_assaad · Accepted solution]

Hi @LoganD601 

You will just need to look at the output of the J anchor of your Join tool. This is the one that will show you IDs on both sheets.  In the example you provided, there was only one Student ID common which is 123. If you run it on the entire data set and look at J anchor output, you should find what you are looking for. See below

[LoganD601]

Ah! I didn't realize that selecting certain rows would affect which ID's would appear. This, however is super simple and should have been obvious to me. Thank you for the assistance!