How to read a txt/csv file remotely after an SFTP connection

Hi everyone, I'm trying to understand how to read a txt/csv file after made an SFTP connection.

After connecting to the remote server and after using the list remote file I got this URI structure:

URI: ssh://name@sftp.myhost:22/home/some_folder/other_folders/file.txt; EXT: txt

Then I have used the URI to String node, the URL to File Path node for get the path and the Table row to Variable node to pass to the Reader node the path variable of the remote file. 

But I got an error:

"The input file does not exist"

Probably I'm missing something.. can someone suggest me how to read the file?

Thanks in advice.

Hi gujodm,

Maybe this thread might be useful? https://www.knime.com/forum/general/file-handling-for-sftp 

Best,

Vincenzo