Assistance needed to differentiate between products

Hello everyone, I need some help with a task to expand a workflow to include an additional product. Right now, I have one product, let’s call it ‘A’, for which I load data and calculate a forecast—it’s a fairly complex workflow. I’d like to add a choice at the very beginning to select between products A and B, and then calculate the forecast for the chosen product. Some of the data is the same for both products, while some is different, but aside from the data, all the steps are identical. I’m wondering what the easiest way to set this up would be. Any advice would be appreciated.

Please describe in some detail how the data is configured/stored. Without this detail, you’ll only get a very generic response. Also if the data sets are different adjustments to your model (or separate models) may be necessary.

I would like to rebuild a KNIME workflow. Currently, we are working with two Excel files that are read into KNIME, where we perform certain operations on product A to generate a forecast. Workflow look like :

The situation becomes more complex as we now need to add a new product (let’s say product B), and essentially reproduce the same workflow for a different set of data.

The goal is not to create a copy of the entire workflow, but rather to allow the user to select which product they want to work with (either A or B) at the very beginning. I know I will need to add two new nodes for reading the shipment and level data for product B, but I am unsure how to set up the workflow so that it distinguishes between product A and product B at the start.

I’ve been looking for a node that could help with this, but so far, I haven’t had much luck :frowning: If you have any suggestions or know of a way to handle this, I would greatly appreciate your advice.

@Patrycja_Piecho you can build a Data App where the user could select a product from a list at the beginning.

The relevant nodes that select the data can then be done by using a CASE switch.

1 Like