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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ven6
Contributor III
Contributor III

Send One mail

Good morning

I have a problem and ask for help.

I have a table with 04 fields (Name, First, DebutVaccance, FinVaccance, duree).

I have a job which consists of reading the data from this table, then lists all the lines where duree is >= 4. and e-mail them.

what I want is for the job to send only one email containing all the lines whose duree >= 4  

this is my job:

0693p00000AaaONAAZ.png

in tFlex_1 :

the difference between DebutVaccance and FinVaccance and store de result in duree.

0693p00000AaaNtAAJ.png

in tMap_1:

i sort the line that duree >= 4

0693p00000AaaODAAZ.png

in TJavaFlex_2:

I build de body of mail

0693p00000AaaO8AAJ.png

And send Mail in tSendMail

0693p00000AaaOIAAZ.png

plz help

Labels (2)
1 Reply
Anonymous
Not applicable

Hello,

 

Please try to use OnsubjobOk trigger instead of OnComponentOk. Let us know if it is OK with you.

 Best regards

 Sabrina