Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

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

Avatar

Level 4

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!

1 Accepted Solution

Avatar

Correct answer by
Level 4

Hi @PoonamBhardwaj,

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 4

Hi @PoonamBhardwaj,

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

Avatar

Administrator

Hi @PoonamBhardwaj,

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

Thanks!