Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Inserting New Row in Pentaho

  1. #1
    Join Date
    Jan 2017
    Posts
    1

    Default Inserting New Row in Pentaho

    Hi,

    I have the following two tables:
    Name:  ForForum.jpg
Views: 524
Size:  15.7 KB
    I want to append the second table to the first, so that SYSNAME, OBJSTRUC, AddChange, EN appear as the header/field names.
    Is there a way to do this in Pentaho?

    I am new to Pentaho

    Thanks.
    Attached Images Attached Images  

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

    Default

    Yes, I'm sure your problem can be solved using Pentaho Data Integration aka Kettle.

    So there's a source table in a database with a lot of columns (sa, sb, sc, sd, se, sf, ...), and a target table with only 4 columns (ta, tb, tc, td).
    Rows from the source table are to be added to the target table in such a way, that for each target column a certain source column must be selected.
    The tables aren't managed by the same RDBMS, therefore a simple SQL statement (INSERT INTO ... SELECT) can't solve the problem.

    If that's your problem:

    Table-Input can provide a projection of the source table via SELECT sa AS ta, sb AS tb, sc AS tc, sd AS td FROM source
    Table-Output can insert rows into the target table.

    BTW: Your attached images are almost unreadable.
    So long, and thanks for all the fish.

Tags for this Thread

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.