Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Problem with Insert/Update from Excel into Mysql table

  1. #1
    Join Date
    Jan 2011
    Posts
    1

    Unhappy Problem with Insert/Update from Excel into Mysql table

    Hi people,

    This is my first post to this forum. I am totally new to Kettle and its functionality.

    I have a problem with Insert/Update function in Kettle. I am trying to migrate data from an excel sheet into a table in MySql periodically.

    Though i managed to make the transformation and enclosed it in a job and ran it.. i have problems.

    My excel sheets dont have any unique key and everyday they are updated. I do not know how to bypass this problem. I tried to create a primary key[ auto increment] in db table and migrate, but its of no use. Everytime the job executes data is getting RE-INSERTED resulting in duplicate records.

    Please help me to solve this problem.
    My excel sheet fields are

    Resource Date Development training Kt Meeting Idle

    My table Fields are

    SerialNumber Resource Date Development training Kt Meeting Idle


    Please help me out to solve the problem of data redundancy.

  2. #2
    Join Date
    Oct 2008
    Posts
    25

    Default

    Hi,
    You either have to specify an alternate key, for example form the combination [resource], [date", or any other combination o unique fields which are not being updated, or if this is not an option you need to use the "Table output" step and tick the "truncate table" box. The latter will reload the complete table each time you run your job.

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.