File download from FTP
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
praneshsapmm
8 - Asteroid
‎12-20-2022
08:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello ,
Iam trying to download files from FTP using Alteryx . File format is as follows : xxxx_<yesterdaydate>.<timestamp>.csv .
Problem for me is to build formula for filename . Iam able to formulate untill yesterdaydate , but how identify the timestamp available in the FTP which is different everyday .
Thanks for the help
Labels:
- Labels:
- Help
1 REPLY 1
Felipe_Ribeir0
16 - Nebula
‎12-20-2022
08:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can make a first call to the root of the FTP folder to see what is inside of it (this is a common property of FTP folders), parse it and then call specifically the necessary and available files. The attached workflow (came from here: https://community.alteryx.com/t5/Community-Gallery/GET-CDI-DATA-Brazil-FROM-CETIP-FTP/ta-p/998914) is doing exactly that if you want to check out and adapt to your case.
