Hey, thanks for your response I created an example bc my current data is too big Example.knwf (10.5 KB)
Joiner would be great if didn’t duplicate data from primary table, but I don’t see an option to disable that behavior and that only works the same as the vlookup (returns the first matched value), joiner is returning all the matched values duplicating the data.
In your secondary table key is not unique. If duplicate keys have same attributes then you can use Duplicate Row Filter before joining. If duplicate keys have different attributes and you want all of them in your resulting table then this is expected. Otherwise take a look at attached workflow and share with us expected result.