file name should ends with column value

KNIME Analytics Platform
1

Hi @BeauWN

I am writing the data to an excel sheet to a network drive using excel writer node to a path and the Excel file name should end with value in the column value(File Name column).
Please find the attached Excel sheet with data.

Thanks,
Subbu

JNJ Constrained Supply Entries - 05_02_2025.xlsx (4.8 KB)

2

Hi,

Please see the workflow below — it uses the File Name column and converts it into a path variable for the Excel Writer node. You can find the file in the KNIME mountpoint folder you have defined. Input file is the one you provided.

Feel free to reach out if you have any questions!

Best regards,

Alpay

filename.knwf (18.9 KB)

2 Likes
3

Hi @alpayzeybek

Thanks for your support,

the file name is getting like this JNJ%20Constrained%20Supply%20Entries%20-%2005_29_2025

But i want the filename to be JNJ Constrained Supply Entries - 05_29_2025.xlsx

Could you please help me to get it like that

Thanks,
Subbu

4

Hi @Subramanyam.
The workflow looks good
Please export and attach your workflow to get better help.

image
image986×710 42.5 KB

Regards

5

Hi @hmfa

I am not exporting it to the local,
I am exporting it to shared drive using SMB connector.
then it is forming like above I have mentioned.

Please let me know how we can resolve it.

Thanks,
Subbu

1 Like
6

Hi.

Can you attach your workflow?

Take a look at

Br

7

Hi @Subramanyam.
Have you connected your SMB connector to the string to path node?

8

Hi @hmfa

I connected the Excel Writer node to SMB Connector node but not the string to path node. Do I need to connect that node as well to SMB connector?

Thanks,
Subbu

9

I don’t have a SMB connection but I suppose the path is build before, in string to path node with SMB: connection.
Try it.
Br