Hello,
I have two sets of data as outlined below. One set has only a subset of record ID's that are of interest, the other set has the full set of record IDs, and two additional columns that have critical information for those IDs. I would like to use the subset to curate the larger set down to only the data that as the record ID listed in the subset. I am having some trouble:
---------subset data---- ------------------Full data set----------
Record ID Record ID Data1 Data2
AAGTCAATC AAGTCAATC SOCS3 5.326
AGGGTCCA GGGTCATTT ABL4 0.314
GGCTTTTA AAGTCAATC LMP2 2.751
etc.
The full set will contain multiple of the same record ID that needs to be kept. Please help, thanks
Colin
Solved! Go to Solution.
You can use the Join tool to bring these two streams together, join them on the record ID and the J output will provide all the matched records.