Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Using simple evaluation transform in job

  1. #1
    Join Date
    Dec 2013
    Posts
    1

    Smile Using simple evaluation transform in job

    Hi all,
    my requirement is to check the row count as 0 or not and accordingly send failure mail if its nt zero
    In case its 0 then a transformation should run.
    I used following steps :
    start --->transformation including sql script +copy rows to result --->simple evaluation --true then running a job or false then a failure mail is send

    i put the condition as count_num (field name) is equal to 0 for success .

    According to database , it should run for true but it's always running for false n sending error mail .

    Pls help me on this...it will be much appreciated

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    maybe it's counting the file heading or something?
    -- Mick --

  3. #3
    Join Date
    Dec 2010
    Posts
    193

    Default

    hi,
    You can use evaluate contents step instead
    Sathish
    Back to Pentaho


    'Be the best Pearl in the ocean of wisdom'

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

    Default

    Quote Originally Posted by Uddi View Post
    I used following steps :
    start --->transformation including sql script +copy rows to result --->simple evaluation --true then running a job or false then a failure mail is send
    Insert a Text File Output just before "Copy Rows To Result".
    You might find something in the file you didn't expect.
    So long, and thanks for all the fish.

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.