Knime Vlookup

[Ulzhan]

Hi everyone!

Can anybody help me with the look up code I have?

The issue is I get repeated data in the output tables. I realized that it is because I didn’t join on all unique keys or vlookup values that both tables share in common. But I couldn’t figure out how to solve this issue.

I would appreciate if anybody shares their ideas!

Thanks!

[elsamuel]

Hi @Ulzhan, welcome to the forum.

It would be best if you provided your workflow along with sample data and an example of your desired output, as well as a more detailed description of the problem you’re facing. As it stands, you haven’t given us much to work with.

[Ulzhan]

Hi @elsamuel,

Thanks a lot for your response. I will try to explain my workflow below.
I used Joiner mode with the following right and left tables:


and the result I am trying to get is:

but ended up with:

The joining columns are ID and Account. I think the problem is that in Account I have several values marching to ID.

Thanks again

[andrejz]

Hi,

Yes, your problem is with several values of the Account column.
You can first try with removing the duplicates with Duplicate row filter in the right table and then join the two tables or you can use Groupby node for grouping values in the right table before and then the join node to join the left table with the Groupby table.
If is possible that there are two or more Placement for the same Account maybe is better to use groupby.

[Ulzhan]

Thanks @andrejz,

I used groupby and I think it works well