Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Rows with different layout

  1. #1
    Join Date
    Nov 2016
    Posts
    5

    Default Rows with different layout

    Hi guys,
    I've a problem with my trasformation. The input of trasformation is a table with this SQL
    Code:
    SELECT
     nome
    FROM casa_editrice
    and another table with this SQL
    Code:
    SELECT DISTINCT
     casa_editrice
    FROM swap_libri
    WHERE casa_editrice IS NOT NULL
    after sort rows step i go in step Merge Rows (Diff) and here I receive the error
    Code:
    The data type of field #1 is not the same as the first row received:  you're mixing rows with different layout. Field [nome String(255)] does  not have the same data type as field [casa_editrice String(255)].
    I've tried also to insert a select value step to rename casa_editrice in nome but in this case I receive a null pointer exceptions
    Attached Files Attached Files
    Last edited by Dennis1; 12-27-2016 at 05:35 AM.

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

    Default

    The first thing you should do is to verify your transformation.
    I stopped looking at your ktr file after stumbling upon a non-existing field configured in Merge-Rows.

    Name:  216822.PNG
Views: 95
Size:  3.6 KB
    So long, and thanks for all the fish.

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.