I have created a detailed workflow for my project. It takes the input, process it and writes the output as I intended.
I get this data monthly and I have to append the data. So, I keep historic data as well.
Now, I wanna avoid opening the wrflw monthly and run it with new data and using few more nodes for appending data. Because, I feel there is an efficient way (make use of flow variable or something).
So, I need suggestions on how to efficiently change my workflow to accommodate the above need and is there any single node for appending data in to one single sheet? (I tried Excel Appender, this appends in different sheet)
what prefents you to load the excel file as well an append the data within the knime worflow using the concatenate node and write it back to the same excel file having the same sheet name (overwrite it)?
Having the previous data inside the workflow gives you more options for e.g. prevention of dealing with duplicates. If your data collection is straight forward and you hasn’t to consider that parts of your previous processed data can’t be included in your ‘new’ data. If so, then congratulations.
I often have this issue of duplicate or modified information and therefore the analysis has to be done from start again.