Passing multiple choices on if switches

KNIME Analytics Platform
1

Hi everyone,

I'm trying to build a workflow for data processing and I'd like to limit the workflow overall processing time by selecting only the relevant KPIs instead of processing everything, every time.

In order to do that I was thinking of using a simple branch made up by:

1. Multiple selection node where I choose my KPIs

2. Transpose node, so that the selection becomes a row

3. Table row to variable node to let the selected KPIs become flow variables

4. If switches nodes (one for each KPI) to route alternative flows depending on KPIs selected. So, for instance, if KPI1 is selected, KPI1 will have to be processed, otherwise skipped.

Everything is fine until step 3, but when it comes to the if-switch nodes, I don't manage to make them work. In particular I'm not able to pass on them the information of flow variables and open/close the right output port accordingly.

Picture of this workflow is attached (don't know why I can't paste it in the body of this post). 

Where am I wrong? Can somebody help please?

Thanks a lot in advance!!

Salvo

 

 

 

2

Hi Salvo,

I'm happy to help you out!

Can you please tell me how many KPIs you want to be able to select? Specifically, are you using the Multiple Selection node to actually select multiple KPIs at the same time, or are you only selecting a single KPI from a list of multiple KPIs?

Cheers,

Roland

3

Hi Roland,

thanks for your reply!

Between a minimum of 10 to a maximum of around 20 KPIs. I'm using the Multiple Selection node so that I can select them all at the same time. 

Looking forward to hearing what the best approach would be for this case!

Thanks and kind regards,

Salvo

 

4

Hi Salvo,

I have created an example workflow that should do what you are looking for. This example uses 5 KPIs. To add more, you need to add one Rule Engine Variable node to the Switch Variables metanode for each additional KPI. You can just adjust the rules from the nodes already in there.

Hope that helps!

Cheers,

Roland

5

Hi Roland,

wow, that's simply amazing!! It's exactly what I wanted to do!! :) :)

Thanks a lot for your help.

Kind regards,

Salvo