Hi Team ,

We have one requirement regarding file drop  in SFTP location For that requirement, we are using File data sets in pega to generate the file . Here we are using the source as a data set in the data flow, and the destination is the file data set.

My requirement: Based on the campaign results, we are saving the data in the database table for us; this table is the source.

Based on the data, we are generating the file.

File Name : pega_campaignid%{YYYYMMDD_HHmmss}.csv

But We are unable to get the campaign ID value in file name . We are using campaign I'd in the file data set for mapping purposes.

for suppose campaign ID value is 42, then the file name should be pega_dm_42_20241015_022255.csv

But we are able to generate the time and date but are unable to get the campaign ID value in the file name.

please help with the solution This is an urgent requirement for us.