Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: DATA from two tables converging into 1 output table.

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default DATA from two tables converging into 1 output table.

    Attachment: snapshot.jpg I am manipulating around 7 input tables in my spoon IDE. 1 of the tables ( TABLE_X ) requires a different computation so what I did is TABLE_X have a separate path so that it data can pass through a different CALCULATOR.

    So as you can see, there are two sides, 1 special calculation, and a normal calculation for other 6 tables. Each sides are working, however, when I try to dump them into 1 output table, there is an error (kettle is performing a rollback).

    When I disable one side, the enabled side works. It goes the same for the other side. When I enable them both, there is a problem.

    What do you think is the problem?

    Thanks!

  2. #2
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: DATA from two tables converging into 1 output table.

    Attachment: snapshot.jpg The screenshot

  3. #3
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: DATA from two tables converging into 1 output table.

    All rows entrering a step must have the same layout.
    Even though the fields coming from a table may have the same name, the ORDER might be different.
    This can sometimes be subtle to detect. You can see if this is the problem by forcing the order in the SelectValues first tab.
    You probably did this in the "PRIMARY SELECT" step, but I would suggest doing it TWICE: one for the left side and one for the right. Because the Select Values step ALSO needs the layout to be the same for ALL input rows ;-)

    Care to share the error details? That might help too.

    Thanks in advance!

    Matt

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.