I need to read a list of files (Excel), do some validations and then write each file in a new path.
My flow is the next: List Files / Folders - Table row to variable loop start - Excel reader - a few column expressions - loop end - Excel writer.
What im doing wrong ?
That is difficult to tell. Maybe you check some examples and hints about Excel and see if you can combine the right tools to get to your goal.
4 Likes
Hi @mracostag97 , I agree with @mlauber71 that it is difficult to tell exactly what you are doing wrong from your very brief description of what you need to do versus what you are doing… but I believe you have the Excel Writer outside the loop when it should be inside the loop. Terminate the loop with a variable loop end.
i.e. List Files/Folders - Table row to variable loop start - Excel reader - Column Expressions (etc) - Excel Writer - Variable Loop End
There may be other things that are wrong, and this may not be right, but you’ll need to give more information to get anything more specific.
2 Likes
In detail what I need to do would be the following: read the files that are in a folder. Then perform certain validations already defined and then write the results in a final directory but with the detail that I need to maintain the name of the original files.
For them my flow is the following List Files/Folders - Table row to variable loop start - Excel reader - Column Expressions - Excel Writer - Variable Loop End. I pass some screenshots of what I have defined. I would really appreciate it if you give me a hand.
Another detail is also that when trying to execute the loop using the same source files (overwriting them) it only executes one iteration
Another detail is also that when trying to execute the loop using the same source files (overwriting them) it only executes one iteration
Is this the only thing that’s going wrong?
Screenshots aren’t that helpful. It’s better to upload the workflow to your knime hub space and share the link here so we can actually work with it.
1 Like