The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

File download from FTP

praneshsapmm
8 - Asteroid

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

1 REPLY 1
Felipe_Ribeir0
16 - Nebula

Hi @praneshsapmm 

 

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.

 

Felipe_Ribeir0_0-1671555179531.png

 

Labels
Top Solution Authors