How to display name of the files which are split using iteration in the success email(tsendmail)?

[Anonymous]

In my job, the output is split into multiple flat files which are placed in the server. the files are split using iteration. I need to display list of file names generated in the remote server in my job success mail.how can i display the file names in the success mail.

[Anonymous]

Hi,

     Please use tFTPFilelist to fetch all the files created under a remote directory. You can later print or send the email based on the data.

      Please refer the below lik for details and sample scenarios.

    https://help.talend.com/reader/hm5FaPiiOP31nUYHph0JwQ/xEnrupGzAR2ep6pI_4P44g

If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

[Anonymous]

I only need the name of the files(not the data) to be fetched.

[Anonymous]

Hi,

    You can fetch only the file name from the component instead of fetching all the details.

Warm Regards,

Nikhil Thampi

[Anonymous]

can you please tell me the process to fetch the file names

[Anonymous]

Hi,

     Could you please try the job flow like below? Instead of tlogrow, you can use your own downstream activities.

Could you please mark the topic as resolved if it the details has helped you? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

[Anonymous]

I am able to get the name of the files and them i am storing those files into a table in my database.But i am not able to get the name of all the files in my job success mail.

My mail format should look like the following:

File Name: ABC.csv

                  PQR.csv

                  XYZ.csv

Please note that i am splitting the files dynamically and those files are generated in the server

Can you please guide me as to what should be the ideal approach.

[Anonymous · Accepted solution]

@Udit1995

    Processing the files in job success mail is a different topic and I would suggest to create a fresh topic so that we are not deviating from the current subject.

   Could you please mark the current topic as resolved since I hope my answer has clarified your original query? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi