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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tSendMail with Variables

Hi
I want to manage the errors in my job. If the execution generate an error, a mail is sent to the manager. To do this, I use the component tSendMail. In the job I need 2 tSendMail.
I would like to insert the content of a variable in the mail but I don't know how to create an variable and insert it in the mail. I try to use "Var" in the tMap but I don't succeed.
How can I do it?
I'm using TOS 2.1 M1 with a java project
Thanks a lot
Labels (3)
7 Replies
Anonymous
Not applicable
Author

Hello
You can use either tJava or tJavaFlex
in begin part :
int myVariable = 0;
Anonymous
Not applicable
Author

Hi
Thanks for your answer
How can I get myVariable in tSendMail?
Anonymous
Not applicable
Author

For example : tSendMail Message :
"Hello" +myVariable
Anonymous
Not applicable
Author

Hi
it isn't tJavaFlex --> tSendMail ? I try your example but I not succeed...
For example, a part of my job is tOracleInput --> tMap --> tOracleOutput --(on error)--> tSendMail
How can I use a field of tOracleOutput in the tSendMail ?
Thanks
Anonymous
Not applicable
Author

Excuse me
I succeed your job (i told you no because an error message was near the component)
Anonymous
Not applicable
Author

I need to include the remote host and local file path in the tSendmail. How do I retrieve these variables and insert them in the mail?
Anonymous
Not applicable
Author

Hello
I need to include the remote host and local file path in the tSendmail. How do I retrieve these variables and insert them in the mail?

Just write them in message filed directly.
Best regards
Shong