Recently I have been working on downloading a batch of excel files from SFTP. I have been successful in establishing the connection using a combination of Text Input Tool and Download Tool and using the URL to download the data. After this I got a list of excel file names that are present in the SFTP directory.
Now, I'm using Dynamic Input Tool to load the data of the excels in Alteryx. I separately saved a file from SFTP and specified the file and sheet in the input file format option of the mentioned tool.
For iterations, I'm using Fullpath field and Change Entire File Path option. Fullpath is URL of the SFTP concatenated with the filename and sheet name.
Fullpath=[URL]+'\'+[Download Data]+'|||'+ <Sheet Name>+ '$'
The issue I'm facing is instead of looking up at the above mentioned directory, alteryx is looking for the files at different location.
So I receive the error of File Not Found: "C:\Users\xyz\AppData\Local\Alteryx\bin\(ahead is the value of Fullpath field mentioned above)
Can anyone guide me on this please?
For you reference, I've attached the screenshot of the error. Due to compliance rules, can't share the workflow. However, if you need clarification on anything please drop a comment.
Thanks in advance!