Add n Columns from vLookup

Hi everyone!!

I need to add n Columns from a secondary table using a key column with my primary table.

I’m using Cell Replacer node, but I think it’s not optimal adding the node n times.

Also the Joiner node it’s not an option because it’s returning several more rows than my primary table.
It’s there another option I could use? e.g.:

Primary Table
Key |Attribute1

Secondary Table
Key|Attribute2||Attribute3||Attribute4||Attribute5||AttributeN|

Expected Result Table:
Key|Attribute1|Attribute2||Attribute3||Attribute4||Attribute5||AttributeN|

Thanks in advance,

Welcome to the forum @Oshcar7

The Joiner node is definitely the solution for this. How did you configure it?
Can you share the data and workflow?

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.

Thank you,

Hello @Oshcar7,

and welcome to KNIME Community!

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.

Example_ipazin.knwf (9.2 KB)

Br,
Ivan

2 Likes

Ok Thank you I’ll remove duplicates from my secondary tables from now on…

Best,

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.