SAP PI 7.31 Dynamic FileName in SFTP Sender channel

[former_member217283]

Hi all,

I need pick up a file from SFTP server but the fileName It depends on current month and year,

I Know use this funcionality in receiver channel but I'm not sure for the sender channel side

Some idea?

Thanks and best regards

[former_member186851]

Hello Monica,

Can you please the entire filename schema.

Only the time period varies?

[former_member217283]

Hi Raghuraman,

the file schema is  fileName_YYYYMM.txt

fileName same is the same value, only change YYYY and MM, the YYYY is the current year and MM is the previous month.

Example:  Current Date: September  2016

fileName_201608.txt

Thanks!

[GauravKant]

Hi Monica,

you can try this with java mapping. PFB blog for the same.

Regards,

Gaurav

[former_member186851]

Hello Monica,

You can try as per Gauravs approach.

And if the files will be placed per day in a single folder only then you can give Filename*.