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?