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!
