How to sort the files fetched from SFTP in file transfer activity for processing- adobe campaign classic help request | Community
Skip to main content
P
Poonam_Dogra
Level 4
March 8, 2022
Solved

How to sort the files fetched from SFTP in file transfer activity for processing- adobe campaign classic help request

  • March 8, 2022
  • 2 replies
  • 1033 views

Hi Team,

How to fetch the files from SFTP with a date-timestamp attached to it and in ascending order of their upload using file transfer activity.

File transfer activity fetches all the files but process them in latest arrived, first served manner[descending order] whereas we want to first process the files which came earlier as first and then so on - ascending order [last modified should be processed at last and first modified should be processed first]. 

Any help is highly appreciated.

Thanks in advance!

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 isahore

Hi @poonam_dogra,

How are you processing the files when they are fetched by the File Transfer activity?

For processing files one by one, normally you would use a File Collector activity after the File Transfer activity, and check the box which says "Stop as soon as a file has been processed". This way the file that has the oldest timestamp of modification will be processed first, and so on, in order.

Add the Data Loading Activity after that to process the file contents.

Run the File Collector and Data Loading activities in a loop, and bring the workflow to a stop when all files have been processed.

 

I hope that helps.

 

Thanks,

Ishan

2 replies

isahore
Community Advisor
isahoreCommunity AdvisorAccepted solution
Community Advisor
March 9, 2022

Hi @poonam_dogra,

How are you processing the files when they are fetched by the File Transfer activity?

For processing files one by one, normally you would use a File Collector activity after the File Transfer activity, and check the box which says "Stop as soon as a file has been processed". This way the file that has the oldest timestamp of modification will be processed first, and so on, in order.

Add the Data Loading Activity after that to process the file contents.

Run the File Collector and Data Loading activities in a loop, and bring the workflow to a stop when all files have been processed.

 

I hope that helps.

 

Thanks,

Ishan

    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    March 17, 2022

    Hi @poonam_dogra,

    Was the given solution helpful to resolve your query or do you still need more help here? Do let us know.

    Thanks!

    Sukrity Wadhwa
      Terms & ConditionsAccessibility statement

      Loading footer...