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
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
1 Like
system
Closed
April 12, 2021, 9:38am
4
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.