Export a excel file with a name dependend on column entry

Hi everyone,

I want to export a excel file from my worflow to a given folder on my Computer. The folder always stays the same but the name under which the file is stored is supposed to change depending on a column value which is constant for a given file-instance.

A simplified excel woud look like this:

Name_Example.xlsx (10.6 KB)

Now the file should be exportet with name “NAME” and if for another instance the column value is “NAME1234” ist should be exportet with NAME. “NAME1234”

Does anyone have a soultion for this? Thank you very much for your time.

Kind regards
Ole

Hi @Ole_Buhl!

I think you should be able to get the desired result if you follow some of the ideas from this workflow: Flow Variable As Output Filename for Excel Writer – KNIME Community Hub.

You could use the table row to variable name to get the unique column value and use that as a flow variable in the Excel Writer node to indicate what name you’d like to save the workflow under.

I hope this helps! Please feel free to reach out with any comments or questions.

Cheers,
Dash

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.