Curate records based on new data stream

[creily]

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

[MichalM · Accepted solution]

@creily

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.