Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: data processing in parent-child manner in pentaho kettle.

  1. #1
    Join Date
    Jun 2013
    Posts
    2

    Default data processing in parent-child manner in pentaho kettle.

    Hi,

    i have an excel input like below. And i want to insert them into database in parent-child manner.

    parent code || child code

    AB || CD
    CD || EF
    EF || GH
    GH || AB


    But i want to restrict the value of 4th row. As it will go into infinite loop.

    thanks in advance

  2. #2
    Join Date
    Sep 2011
    Posts
    26

    Default

    To insert them in parent-child manner you need to have a root member. Do you have it?

  3. #3
    Join Date
    Jun 2013
    Posts
    2

    Default

    I do not have predefined root element.In the below example, AB is the root element.
    Just want to restrict AB again in his sub child or child.

    AB>CD
    >EF
    >GH
    >AB (Here its wrong)
    >CD

    Thanks for the reply.

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.