Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Newbie -Help Appreciated in setting up job

  1. #1
    Join Date
    Jun 2013
    Posts
    21

    Default Newbie -Help Appreciated in setting up job

    Hello,

    I am very new to Kettle and would like to ask for help in setting up a job/transformation with teh following capability:
    1. Check Database table to see if any rows currently exists
    2. If rows exists, move the data to a backup table and clear current table
    3. Read excel file
    4. Store excel file into table that was cleared
    5. Done

    My problem has been with the parallel execution of the transformation. I have tried flow control but guess i am not doing correctly.
    What is the best way of performing these actions?

    Thanks

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

    Default

    You will need two transformations.
    One to copy rows from the landing table to the archive table - a Table Input and a Table Output step will do.
    And one to import the Excel rows into the landing table - use the "truncate table" option of the Table Output step this time.
    To run the transformations serially, put them in a job.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Jun 2013
    Posts
    21

    Default

    THank you marabu

    Appreciate your help

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.