Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Delete all files

  1. #1

    Default Delete all files

    Hi PDI forum,

    I have to read one or more CSV files in a directory using wildcards, to load data into a DB . In the meanwhile, the transformation writes a data backup and a LOG file.

    After this, I must delete the files, but I don't know exactly their names, because of the wildcards.

    I must schedule this every 12 hours, so I've made a Job with 3 steps:
    - Start
    - Lauch the Transformation
    - Delete the files

    But the 'Delete file' Job entry needs the exact file name, and here wildcards don't work.

    How may I delete in the last step of the job the same files I defined in the Text File Input step of the Transformation by using wildcards?

    Thanks a lot for your help.

    Andrea

  2. #2

    Default

    Hi Andrea,

    Which version of PDI are you using?

    Samatar

  3. #3

    Default

    I'm using the 2.5.1.

    Andrea

  4. #4

    Smile

    Ok,

    In 2.5.1 , the best way to solve your pb is to use a shell job entry with CMD like
    DEL %1 (please see picture).

    I attached a sample.

    If you want to use delete file job entry, you need to create a sub job in order to
    deal with one file at a time (create variable & use it in delete file job entry).

    Anyway, why not upgrading to 2.5.2 : a lot of bugs were solved and you will find
    a delete files job entry that will allow you to use wildcard.

    Take care

    Samatar
    Last edited by shassan2; 01-24-2008 at 06:06 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.