rfduboissl
New Contributor II
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Email snap with both pipeline variables and HTML table?
1). Data going into the email snap … the $variables must be at the same level as the table, ( I had each of them coming in as separate documents). 2). email type is HTML table, Table data path is $table 3). Final Template body html is: " Good morning Team,Today’s DQC values for your review. 1. Attunity Load Items Status/Issues a) Status – Complete. b) Issues – No issues 2. PDW Load Items Status/Issues a) PDW – Completed at " + $complete_PDW + " b) CALL Center – Completed at " + $complete_CC + " c) SpecRx – Completed at " + $complete_SPECRX + " d) MHK – Completed at " + $complete_MHK + " e) Reporting Cluster – Completed at " + $complete_RPT_Cluster + " f) Issues : None 3. Please find the DQC errors in the below table "1.5KViews0likes0CommentsRe: Email snap with both pipeline variables and HTML table?
@cstewart, I’ve attempted to use your solution, but I need further info. Do you have a snapshot or examples of the mapper snap going into this email snap as well as the email snap, showing the configuration. I have the email type set as “HTML table” using your solution and my email snap continues to give me => Failure: Template body: $complete_PDW is undefined. Below is the html in my template body: "<DOCTYPE html> <html> <head></head> <p>Good morning Team,Today’s DQC values for your review.</p> <body> <p>1. Attunity Load Items Status/Issues</p> <ul></ul> <li>a). Status – Complete.</li> <li>b). Issues – No issues</li> <p>2. PDW Load Items Status/Issues</p> <table border=1> <tr></tr> <tr><td>PDW – Completed at: </td><td>" + $complete_PDW + " </td></tr> <tr><td>CALL Center – Completed at: </td><td>" + $complete_CC + " </td></tr> <tr><td>SpecRx – Completed at: </td><td>" + $complete_SPECRX + " </td></tr> <tr><td>MHK – Completed at: </td><td>" + $complete_MHK + " </td></tr> <tr><td>Reporting Cluster – Completed at: </td><td>" + $complete_RPT_Cluster + " </td></tr> </table> <li>f) Issues : None</li> </body> </html>"1.5KViews0likes3Comments