I am importing many excel files with less or more identical data structure. Inside the loop I modify the table columns so the output is one table. After the loop I also modify this table (add new columns and join with other tables). I think that the workflow works well but in last case I have found that in one join some rows were duplicated. The total number of rows must be equal to the sum of all rows in the excel files. I find the error and resolve it but … What I want is to create a separate table inside the loop (group some columns and count an sum some values) and compare this values with the values in a table (with same group method) at the end of the workflow. So I need that the (temporal) values in the GropuBy node inside the loop are stored in a separate table every time the excel file is processed. How can I do this? Thank you Andrej

Hi andrejz , I think I now understand your problem :slight_smile: I think you are looking for the loop end (2 ports) node: [image] Loop End (2 ports) Node at the end of a loop. It is used to mark the end of a workflow loop and collects the intermediate results by row-wise concatenation of the incoming tables… There you can create two tables inside the loop and put out both tables in the end :slight_smile: Attached your workflow slightly changed Test.knar (59.1 KB) However if you need more than 2 tables - then I would suggest to run the loop multiple times (not the prettiest solution by most likely the easiest: ->see workflow1 Hope this somewhat helps :slight_smile:

Populate new table inside loop

KNIME Analytics Platform

ipazin May 22, 2020, 2:57pm 8

Hi there @andrejz,

glad you made it.

Regarding Loop End with dynamic ports it was wished here as well:

Will check it and get back to you.

Br,
Ivan

1 Like