Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: File Existense Transformation

  1. #1

    Red face File Existense Transformation

    Hi ,

    Today I am looking for a solution for file existense to be tested in transformation and execute the condition accordingly.

    Name:  File_Exist_Transformation.JPG
Views: 32
Size:  24.3 KB

    scenario
    I am running this job attached screenshot above and linked transformation in "File existence check" transform for checking file existense.

    IF Exist then run the true condition and generate some basic output else (False Condition)drop a mail with the error message file not found through mail Error(Mentioned above).

    Below is a transform connected to File existense check.

    Name:  File_Exist_testing.JPG
Views: 34
Size:  12.2 KB

    Issue

    When I am running transform, I am getting result always true becasue of the transformation linked in "file existense check " is always returing a default value true in it.
    Condition return true and since file did not found in the fetching directory, I get error message failure in a log file due to transform 2 which is looking for the file.

    Requirment

    Steps how to check particular file existence in any directory throught feature file exist.
    and how to execute above job to get result.


    All the jobs are attached in a mail.
    Please use below attached transform and job for getting clear picture.
    Attached Files Attached Files

  2. #2
    Join Date
    Mar 2013
    Posts
    127

    Default

    Hi,

    Since transformation always runs without any error, You can check file exists in job and you can connect failure hop to mail step and success hop to transformation (which loads file)

    may be like this...


    Name:  Capture.PNG
Views: 29
Size:  11.7 KB



    Quote Originally Posted by Abhshek.Mishra View Post
    When I am running transform, I am getting result always true becasue of the transformation linked in "file existense check " is always returing a default value true in it.
    Last edited by MateenSA; 06-16-2015 at 03:21 AM.

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.