How to collect multiple file from SFTP and load the files sequence in the workflow. | Community
Skip to main content
R
rudraPraveenKumar
Level 2
July 25, 2023
Solved

How to collect multiple file from SFTP and load the files sequence in the workflow.

  • July 25, 2023
  • 1 reply
  • 958 views

Hi All,

 

I want to load the data from SFTP to Campaign and i have more than one file in SFTP folder, so i want to run one by one sequence the file format .csv or .zip, Please suggest me how can i achieve this

 

i can able to do only single file using file transfer activity, kindly suggest

 

Thank You 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by LakshmiPravallika

Hi @rudrapraveenkumar ,

 

Please use the File transfer activity and select the external account and put the filter as shown below for .zip files

 

Also, please use the Data loading activity to read the file from the transition.

 

In the similar way , Please use the other file transfer activity same as shown above, but please change the filter from "*.zip" to "*.csv" to read the .csv files in that Directory.

 

Regards,

Pravallika.

 

 

 

 

 

1 reply

LakshmiPravallika
Community Advisor
LakshmiPravallikaCommunity AdvisorAccepted solution
Community Advisor
July 31, 2023

Hi @rudrapraveenkumar ,

 

Please use the File transfer activity and select the external account and put the filter as shown below for .zip files

 

Also, please use the Data loading activity to read the file from the transition.

 

In the similar way , Please use the other file transfer activity same as shown above, but please change the filter from "*.zip" to "*.csv" to read the .csv files in that Directory.

 

Regards,

Pravallika.

 

 

 

 

 

Terms & ConditionsAccessibility statement

Loading footer...