Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to create a status report and send on mail body

  1. #1
    Join Date
    Nov 2016
    Posts
    1

    Question How to create a status report and send on mail body

    Hi Guys,

    I'm new on PDI and I'm trying to create a report on mail body.

    I need to create a table with a fixed column that is the System Names and another column that value is a flag with the status of the system (I will get this information by a SQL)

    How can I a merge the information between the fixed column (system name) and the SQL (status) and how can I put this table into Mail body?

    e.g.:

    System Name Status
    System 1 GREEN
    System 2 GREEN
    System 3 AMBER

    Please reach me out for more details with necessary.

    Thank you.

    bts

  2. #2
    Join Date
    Jun 2016
    Posts
    107

    Default

    Hi

    you can get the values from table one by one then merge and set to a variable with concatenate(i.e, p1=p1+value)
    then configure the parameter in mail body.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.