Changing Names of multiple Files adding a Date and Company Name

[Violeta]

Hello there,
I am quite new to KNIME and can’t find a solution of how to change multiple file Names.

I get files with company code and date on a monthly basis. I need to add a company name to a file name from a list. Like in the example. How can I do it?
Final Result should look like that:

[Daniel_Weikert]

CSV writer has a variable tab which allows you to specifiy the path (including the name) of your output file. So you can use e.g. string manipulation variable node to create the specific path and filename.
I would suggest checking out some workflows on the hub on how to work with variables
e.g.

Flow Variable As Output Filename for Excel Writer – takbb

br

[rfeigel]

This workflow is a template for changing filenames.

Changing Names of Multiple Files – rfeigel

Look at this link for a method for reading full file paths and writing the changes.

Rename Files – knime

[rfeigel]

@Violeta I’ve added a branch with a Value Lookup which will be useful if the two input tables aren’t in the same order.

Changing Names of Multiple Files rev 1 – rfeigel

[rfeigel]

@Violeta If this works for you could you please mark it solved?

[Violeta]

Dear @rfeigel thanks for your help. I get the Files and Folder from List Files node. I adapted the workflow a bit to get the new file name, but the workflow is not complete. How do I overwrite the existing files name with the new files names in the folder now. Below my workflow. Thank you!

[rfeigel]

Its not a simple overwrite since the filenames aren’t the same. Let me think about it.

[rfeigel]

Try this, I’ve got it set to write a new set of files. If you want a complete overwrite, tick this.

Changing Names of Multiple Files rev 2 – rfeigel

[Violeta]

Dear @rfeigel I copied your workflow and it works! Thank you very much!
BR Violeta

[rfeigel]

Your welcome. Glad I could help.

[amaralarthur]

I think the best approach is to read and write these files to another folder with the changed name. In my opinion, modifying the source file name is dangerous as it can lead to data loss.

I would address this problem with an approach in which a CSV Read Node with a variable port receives the new filenames prepared by a looping mechanism.

From there, the data from each CSV would be used to write to a blank CSV file named with the new name, in a new location.

[rfeigel]

My workflow has a choice of whether to overwrite the original file or add a file with a new name.

[Violeta]

Thanks for the suggestion. It seems there are multiple ways to change files names. But the above solution worked for my case.