Fill in table 1 with values from table 2

KNIME Analytics Platform
1

I have two tables, for example:

Table 1

Product Identifier Customer 1 Customer 2 Customer 3 Customer 4
12345
12346
12347
12348
…

Table 2

Product Identifier Price File 1/GBP Price File 2/GBP-10% Price File 3/EUR
12345 50 45 60
12346 17 15.3 20.4
12347 100 90 120
12348 35 31.5 42
…

I would like to fill in table 1 with price values from table 2 depending on which price file a customer uses.
Eg. Customers 1 and 3 use price file 1, customer 2 uses price file 2 and customer 4 uses price file 3.

So my result would be this:

Product Identifier Customer 1 Customer 2 Customer 3 Customer 4
12345 50 45 50 60
12346 17 15.3 17 20.4
12347 100 90 100 120
12348 35 31.5 35 42
…

At some point new customers will be added and the price file that a customer uses may change.

What is the best way to fill in table 1?

2

Hi,

It’s probably not the best way but seems to be working - see attached workflow.
Zero output port of the last “Pivoting” node contains what you need.
Remember to update table “Customer_PriceListNumber” which assigns specific
price file for each customer.

Martin K.

Fill_in_table.zip (35.6 KB)

3

Hi Martin

Thanks for the workflow, I’ve got it working with our proper data now.

Thanks for your help
Heather