SFTP: Multiple files downloaded?

[NeilMcK]

Good afternoon,

I am looking to download multiple files from an SFTP server that have different filenames but do have constancies in the manner in which they are named e.g. All the files I need end yyyymmdd.csv.

Is it possible to download all these files in one pass using for example *yyyymmdd.csv"?

Any assistance would be warmly received.

Thank you kindly in advance,

Kr,

Neil

[IraWatt]

Hey @NeilMcK,

I believe you need to give the full path. If they have they have the same schema and you have their names/can generate there names you could use a batch macro to download them all at once. The community has some great videos on batch macros if you havent seen them.

[NeilMcK]

Thanks Ira,

I will have a look at the videos and see if that will solve my problem.

Kr,

Neil

[Felipe_Ribeir0]

Hi @NeilMcK 

I dont know if you already solved it, but here i solved a example exactly like what you need. This FTP Server is public, so you can just run and understand how it was solved.

GET CDI DATA (Brazil) FROM CETIP FTP - Alteryx Community

[Felipe_Ribeir0]

Hi @NeilMcK 

It worked?