Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to send mail for tmap rejects

i am using tlogrow to capture tmap rejects. i want to send these rejected records through mail using tsendmail .

can you please suggest how this can be achived

 

0683p000009LuOd.png

Labels (2)
4 Replies
TRF
Champion II
Champion II

Hi,
I suggest you not to send 1 email per reject.
Collect all rejects into a file then (onSubjobOk or at the end of the job using a tPostJob) send then email with the reject file as an attachment.
With this method you'll improve performance (1 email to send), you can design the reject file schema as you want and if necessary you can aggregate rejects from different steps of the job into the same file.
Hope this helps.

Anonymous
Not applicable
Author

To add to above, you may create  a global variable to monitor the reject row count , after storing the error in file add a runif condition for counter>0 to to send the email

Anonymous
Not applicable
Author

Hi thanks for that, can u please show how the flow would be

Anonymous
Not applicable
Author

waoo...please show us how with screenshoot