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

[Poonam_Dogra]

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!

[isahore · Accepted solution]

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]

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!