Adding a folder location with backslashes to a string

[aehrenworth]

I am trying to add this string to an existing column and cannot figure out how to get it to not error with the backslashes (this is a File Server location).

"\AWSWIGNVAW0001\OpsFileServer\DOT\EPIC 7-30-2024\attachments\files"

This expression is not working:

join("\AWSWIGNVAW0001\OpsFileServer\DOT\EPIC 7-30-2024\attachments\files",$FileName$)

Any suggestions?

[mlauber71]

@aehrenworth double escape the backslash

\\ for \

[JPollet]

Hi,
Escape until the expression in the editor becomes red !!!
From this :

to this

You have to add also \\ at the end I presumed.
Joel

[aehrenworth]

Thanks I figured this out about 5 minutes after submitting. Upskilling quickly in our company as they have forced us to move to KNIME from Alteryx after about 7 years of using it. Finding it easier and easier each day.

[mlauber71]

@aehrenworth

move to KNIME from Alteryx

I assume you will then be familiar with these resources. If not I just put the link here. Also it is always good thing to ask on the forum since there are several people who have experience with the migration themselves and all KNIME users here are happy to help.

From Alteryx to KNIME | KNIME

Alteryx to KNIME Migration FAQs | KNIME