Following the KNIME Hub link, you can find a possible solution to your challenge. I tried to build the whole workflow without stepping on scripting nodes. Transfer the files with Transfer Files node was an easy task to be configured within a loop, however I couldn’t complete the file rename task.
As you can appreciate, coding transfer + rename into R is very simple. Then, you can avoid PowerAutomate extra tasks.
P.S.- PDF Files aren’t included in the workflow. The workflow is saved with data. Aiming to re-run the workflow you will have to point source folders in your system, and edit reference folders within R Snippet code.
Wow, great to see people committed to helping.
I’m still new to Knime, but I hope I can help too.
It’s great when you send me the code, so I can analyze it.
About the R language, I took a small course on Google Analytics, but I found the language difficult. I didn’t adapt.
I will download your code and studie step by step analysis.
I managed to do it using Power Query and Power Automate.
In the power query I read a folder and did the ETL (easy), then I used PowerAutomate Desktop (youtube video (very easy to)
But I want to learn in Knime. It is a magnificent tool. The best I’ve ever met. Incredible.
Therefore, the code represents the whole multiline text within the cell. The first capturing group is the target row and it is represented by “$1”. Then we are replacing the whole text with only the capturing group.
I’ve just updated the workflow in KNIME Hub referenced in previous post. As you can see, ‘Transfer Files’ node can only copy or move (by deleting source files option) to target folder…
The best option to copy_and_rename() from my experience is by coding it into R. Would be interesting to know, if rename function can be achieved from KNIME base nodes.