How to use flow variable in row filter such as current column name in column list loop

[fapolis]

I have a dataset and workflow set up in a loop. The loop runs through a table with two sets of columns with different names. I want to filter specific rows in each column set based on the column name for each iteration. I can’t do this in the workflow because I can only associate one set of columns with the current column name flow variable. Is there a way to create another flow variable for the other set of columns so that I can use the row filter?
structure.pdf (38.8 KB)

[alpayzeybek]

@fapolis

I have a dataset and workflow set up in a loop. The loop runs through a table with two sets of columns with different names. I want to filter specific rows in each column set based on the column name for each iteration. I can’t do this in the workflow because I can only associate one set of columns with the current column name flow variable. Is there a way to create another flow variable for the other set of columns so that I can use the row filter?

Hi and welcome to the forum!

I’ve put together a simple solution using the Math Formula (Multi Column) node — no need for loops in this case.
Feel free to check out the screenshots and the KNIME workflow I’ve attached below.

Hope it helps!
Best,
Alpay

VariableFlow.knwf (43.8 KB)

[fapolis]

Loop_test.knwf (83.5 KB)
This is my workflow, I want filter and group the quantity of numbers 13, 14 and 15 in each column test represent of check columns existing numbers, but I do not get use flow variable in criterion 4.

[fapolis]

The final loop result is
Jogo_1 verificacao Jogo_2 verificacao(item#1) Jogo_3 verificacao(item #2)
13 18 13 16 13 17
? ? 14 1 14 1

[fapolis]

Thanks for reply, but I need the final result to be the sum of the values ​​in the verification column referring to the Game_ column, that is, Game_1 and verification, Game_2 and verification(item#1) and so on.

[alpayzeybek]

Could you please upload the table here? The ‘Game’ column wasn’t included in your initial post, and the flow can only work with the data you’ve mentioned here.

[fapolis]

Sure, this is table used.
test_loop.csv (73.7 KB)
Thanks for all.

[alpayzeybek]

Hi,

I’ve added extra columns to calculate the sum of the check columns and included a final table based on the check results per game.

Please see the screenshots and the revised flow below. The issue was resolved using the math formula with multi-column functionality and some data manipulation.

Hope this helps!

Best regards,
Alpay

Column Loop.knwf (40.4 KB)

[fapolis]

Thanks for the help, I was also able to perform the filtering and get the desired result.
Loop_test_1.knwf (122.0 KB)