Join just some values of a column in a spreadsheet

Hello!

I am new using Knime so I have one doubt.

I have two spreadsheets, one about product consumption by sector and other about product stock. And I want to make a weekly report that shows how much stock is left when the sector asks for a product. But of course I have more products in the stock, so I want to show in my spreadsheet only the ones that I am consuming that week.

To exemplify:
First spreadsheet:
image

Second spreadsheet:
image

Spreadsheet that I want to achieve:
image

You can use a Joiner node to combine the two tables on Product, and afterwards a Math Formula node to calculate the Still in Stock value.

4 Likes

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