File download from FTP

praneshsapmm

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

Felipe_Ribeir0

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.

AverageCDI.yxzp