Knime excel cell updater, need to read from an excel file and write to a different excel file

[chaithuj]

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\Settlements_Prelim_File_Analysis_IBM.xlsx

2. write to a different excel which has the same name as input file with an _QA
   N:\TOOLS\Allocaton Settlement Process Docs\CALAUTOMATION\Settlements_Prelim_File_Analysis_IBM_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

[iCFO]

You can combine multiple variables into 1 port connection using the merge variables node.

Merge Variables

Did you also need help altering an input file path by appending _QA?

[chaithuj]

yeah that would be really helpful and I need help on altering an input file path by appending _QA?

[chaithuj]

@iCFO , Thank you very much for suggesting this node

[iCFO]

file path _QA.knwf (94.4 KB)

This should work once you point the excel reader toward the local path of your excel file.

[chaithuj]

@iCFO , Thank you very much, that worked

Regards
Chaitanya