Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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.

 

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

@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 

 

   

View solution in original post

7 Replies
Anonymous
Not applicable
Author

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
Not applicable
Author

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

Anonymous
Not applicable
Author

Hi,

 

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

 

Warm Regards,

 

Nikhil Thampi

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

Hi,

 

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

 

0683p000009M1Y7.png

 

 

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

 

Warm Regards,

 

Nikhil Thampi

Anonymous
Not applicable
Author

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
Not applicable
Author

@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