I’m looking at applying a worksheet to a folder, taking a simple worksheet with some formulas, and applying it to a folder full of more complex files.
Id want these worksheet to allow the formula to apply and then pull out a row from each file and paste that into a separate Excel file for each building up a data set.
Is this possible? Ive just started to use Knime and cant seem to figure it out.