I had some issues finding a way to achieve for this and i wanna help to someone with have troubles as me, i did this:
Connect to aws.
Choose my s3 bucket.
Make a string manipulation to create a variable route using “\” instead of “/”.
Connect my s3 connection with a String to path (variable) using a File System Connection (The blue one). With this, the file system will show Amazon S3 as unique option.
After that, you can use the var path for other nodes, for exampe one excel writter.
Thank you so much for the workflow. You can also upload your workflow to your public space on the KNIME Community Hub with relevant tags and descriptions.