Lookup fields from one input against another input.

RVDL

Hi All,

I have attached a simple workflow.

Input 1 contains a list of identifiers. I want to know which of those identifiers appear in Input 2 (in column Class ID). When using "Join", I end up with many rows with the same "MyID" as shown below.

Of course I can use "Unique" to end up with two rows showing "MyID" = 329 and 5747.

But somehow it feels that I shouldn't be using "Join" here. Is there a cleaner way of doing this?

Thanks

Example.yxmd

DataNath

Hey @RVDL, I'd say a Join here is actually a good way to go. That said, if you just want to check for the presence in the [Class ID] field in input 2, I'd make a distinct list. Like you mention, you could use the Unique tool. Here I've just used a Summarize tool, grouped by [Class ID]. From there you can do the Join and the Inner product are the IDs present in both Input 1 and 2.

Example (2).yxmd