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)
This is only the first step, I will have some extensions to this after…
Thanke you in advance
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.
Hi @elsamuel Samuel, thank you very much for your solution. It has helped me super and finally works
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.