Data extraction from .xls file/s
Good morning KNIME world, I’m new here and I’m using KNIME for hobby for 1 year to find licensed software alternative solution. I used KNIME successfully for MS/MS data extraction with better result than licensed software. Now I’m trying to do something different.
We have a big excel file we too many data inside (ex. Assigner, Data, TubeID, etc) and I would like to generate another excel file with sheet for every for ex Assigner. I found the way to do it.
The problem is that I need to do this operation every week to have a final .xls with all months data inside.
The problem is that every time I made this operation, it overwrite the previous file instead of append on it.
Do you have any solution for this? There is an Append option on Excel Writer node, but doesn’t work with Sheets. Here you can see the workflow.
Thank you for your time!