File name variable values

I am generating an export file for a client and I need to append a timestamp at the end of the filename. How do I do this in Diyotta?

Beginner Asked on October 30, 2019 in Diyotta Studio.
Add Comment
1 Answer(s)

Hi Breiney,

In order to append the timestamp at the end of  file name, follow the below approach

Steps

Dataflow:

1.Create a parameter in the dataflow, and provide the system parameter $$CurrentDateString as shown below

RE: File name variable values

2. Then move the Load properties present in the File Target and append the dataflow parameter to the file name.

RE: File name variable values

 

Jobflow:

1.Create a parameter in the jobflow, and provide the system parameter $$CurrentDateString as shown below

RE: File name variable values

2. Then traverse to the Load properties present in the design job for File Target and append the job flow parameter to the file name.

RE: File name variable values

 

Output:

RE: File name variable values

Expert Answered on October 31, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.