Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Dynamic Mailing to users whose emils are specified in excel file

  1. #1
    Join Date
    Oct 2013
    Posts
    27

    Default Dynamic Mailing to users whose emils are specified in excel file

    I am trying to mail seperate files to different users -whose email ids are specified in excel file. How to design my transformation?

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Row processing is done in a transformation.
    You will need an Excel-Input step to drive the transformation.
    Obviously you will need a Mail step, too.
    Please note that the Mail step is configured via fields, so you'll have to use an Add-Constants step to provide the values needed.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Mar 2013
    Posts
    127

    Default

    Hi Marabu,

    What if email-id's are duplicate and files are distinct(unique) like reading from Get files from result set (which will also give log files from parent/grand parent jobs), i have a very similar requirement ...

    You can shed some light here


    Regards,
    Mateen

  4. #4
    Join Date
    Oct 2013
    Posts
    27

    Default

    Thanx Marabu,
    I had already added 'add_constants' step.
    what is used here is:- My file name also contained employee ids. Hence i fetched those ids and merged joined with my excel input step(it contained emp_id and mail) ;so that I could map each file with that employee id. Then I mailed the output dynamically.

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.