Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Want to have a single record from two records.

  1. #1

    Default Want to have a single record from two records.

    Hi All,

    I want to have a single record from the following Source table.

    Idno Date Type_Code
    100 12/9/2010 G
    100 12/9/2010 H
    100 5/11/2011 C
    100 5/11/2011 D

    Expected Output:-

    Idno Date Type_Code Next_type_code
    100 12/9/2010 G H
    100 5/11/2011 C D

    Thanks in Advance,
    Last edited by LearningPentaho; 09-15-2011 at 07:36 PM.

  2. #2
    Join Date
    Nov 2009
    Posts
    688

    Default

    Just use the Group By step.
    1. Field that make up the group are Idno and Date
    2. Aggregates is Type_Code

    Grtz.

    Johan

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

    Default

    You also need the "Analytic Query" step to get the value of the next row.

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.