Combine two Tables

Hi everyone, im new at Knime and please you to help me to combine two tables (Table 1 / Table 2).

Table 1.xlsx (10.2 KB)
Table 2.xlsx (10.4 KB)

The output should be, that I have to every Purchase Order Number the Invoice Number (see Picture Below)

Output|690x64

This is only the first step, I will have some extensions to this after…

Thanke you in advance :slight_smile:

Welcome to the forum, @ARock1980.

For this, I’d use a Joiner node to do an inner join on the Supplier Number (IvS), Supplier name (IvS), and Volume columns. You can then modify which columns you want to keep in the final table.

6 Likes

Hi @elsamuel Samuel, thank you very much for your solution. It has helped me super and finally works :slight_smile:

1 Like

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