What I need to find is a way to keep these changes even if the input files change.
I created a way of saving an excel file whenever a change has been made in the table editors. The columns FPL_MIN and FPL_MAX can be changed to whatever value. The last component checks for changes and either saves an excel file to a folder called Temp in the current Workspace if changes have been made or throws an error when no changes have been made (and does not create an excel file).
ExampleWorkflowSavingFiles.knwf (168.0 KB)
Now the thing I cant get my head around is how to proceed with this information.
The guy I create this workflow for does not want to add more complexity by having to select the correct Excel file for the next steps in the workflow so my solution does not work for him.
I need to find a way to save changes in these Table Editors even when the input files change somehow.
Thank you all and have a nice day!