Knime excel cell updater, need to read from an excel file and write to a different excel file
Hi,
I have a situation where I have to read from an excel file and write to a different excel file and I tried using Excel cell updater and it works perfectly fine as in below screenshot
Now I have a situation where instead of specifying the path and file name specific to the client, want to make it generic. My problem is
1.
have to read the Input excel sheet as a parameter
N:\TOOLS\Allocaton Settlement Process Docs\CALAUTOMATION\SettlementsPrelimFileAnalysisIBM.xlsx
1.
write to a different excel which has the same name as input file with an _QA
N:\TOOLS\Allocaton Settlement Process Docs\CALAUTOMATION\SettlementsPrelimFileAnalysisIBM_QA.xlsx
I used list file folders and tried to read input file name and used table row to variable
and used this as a path variable for Excel cell updater node
This worked.
But I need to write to a ouput excel using a path variable, it doesn’t let me take 2 varabbles
is there a better way of doing it
Read Input file from a dir and wite to the same dir with same name appended by _QA
and not hardcoding the file names