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

[nagakavyasri]

@RVDL Join works on 1:1 mapping, since there are multiple Class_Id in Input2, the output shows multiple. Unique with Class_id field before Join will give the appropriate output.

[DataNath · Accepted solution]

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.

[RVDL]

@nagakavyasri  @DataNath  Thanks both.